Skip to main content

[Solved]:How to make SharePoint site or any site to work in READONLY mode

Some times there will be situation where we have to make the site to work in read only mode for the end user so that they can access the site , get the contents . That's it. They should not add any more data .This type of situation comes because of certain reasons. one among them i can say is, we are moving the database to another server and later we are making all the users to access new server for further usage. During this process if the user adds data it will be big problem. So let's make users to use the site in readonly mode.

Solution:
  In order to achieve this , follow the following steps:

1. Open the visual studio management studio and right click on  the database to which your site is attached to save the data. Now select the Properties






















2.click on the "Options"




















3.Scroll down till "State" and make the Database Read-only to True



















Now..it is done!!!.. Let the user access the site but not to add any data


Hope this may help someone

cheers
pradeepa achar

Comments

Post a Comment

Popular posts from this blog

error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object

While deploying using Visual studio, we may get an error "error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object" Solution:  Don't get  panic ..Simply restart the visual studio with the solution which you wanted to deploy on to the site This may help some one. -cheers pradeepa achar
5 comments
Continue »

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults

Hi Guys,   I came across this issue  today. I was totally blank. Later i started observing the issue and realised that, this issue is caused just because of  mismatch of assembly version or any attribute  in Security token service's web.config file (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\SecurityToken). Actual issue was i upgraded the assembly version and didn't do changes in web.config file of security token service This blog helped me to fix my issue http://underthehood.ironworks.com/2011/05/sharepoint-2010-an-exception-occurred-when-trying-to-issue-security-token-the-server-was-unable-to-p-1.html thanks pradeepa achar
Post a Comment
Continue »

The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator

You might have developed a functionality where data is being saved in a SharePoint list. By the time you developed this functionality it was working fine.As users adds the data , some day your functionality doesn't work. That means, the data which is present in the list is not being retrieved. Don't be panic. Just open the LOG file which is present in 14 hive folder. You will come to know about this bug with the statement -"The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator". Now what you have to do is, go to central administration site.  1.Click on Manage web application 2.Select the web application on which your sitecollection is created. 3.Click on General settings and select Resource throttling 4.by default list view threshold would be 5000. your list might have data more than 5000. So , increase the number to required threshold limit. you can make it 10000, 20000 like this. Do a i...
2 comments
Continue »