Hi, Using SharePoint 2007 Enterprise Ediiton. I had my Sharepoint on SQL Express where the 4GB is full. I have upgraded the SQL express to the Full edition which went well. under "Site Actions", I see only "Site Settings". I don't see any option to create a new site or create a new item under any list. It is like my SharePoint is set to read-only. I am still a Site Administrator but I don't know how to troubleshoot this. The hive logs are huge and I don't know what to look for as I don't see any error in the web interface. Any suggestions to lock this down? Thank you Nmap

Hi, As you mentioned you have exceeded DB limit. try following steps. Open Central Admin > Application Management > Content Databases Select the web application from the drop down Click on Add a new Content Database Then provide DB server and DB name . Now in the Database Capacity settings change "Number of sites before a warning event is generated " to "9002 " And "Maximum number of sites that can be created in this database " to "15002 " Click OK And then check Site action button in site. Hope this helps One more thing I would like to add - If possible you can upgrade to SQL Server 2008 R2 Express Edition which has 10 GB per DB limit. above is the procedure through which we can add a blank DB to existing site and now your site will add content to newly created DB up to 4GB Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

Hi, I have followed your instructions and it did not help. After the changes, I perfomed also iisreset. I have found an existing list which I opened in datasheet view, I tried to enter a new line and it gave me an error saying I don't have any permissions. Any other suggestions? Thanks

Hi, How many site collection you have in current DB ? You can split some of the site collection to new Content DB using STSADM command Stsadm -o mergecontentdbs -url <URL> -sourcedatabasename <database name> -destinationdatabasename <database name> -operation 3 -filename <file name> before performing above command please refer http://technet.microsoft.com/en-us/library/cc825327(office.12).aspx Because your existing sites grow in the same content DB. So move them first in new content DB and then try. Please let us know results.Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

I am seeing the error below which I suspect that it may be related. The account "domain\username" is my farm administrator account. I know that the account is valid and credentials are correct. Event Type: Error Event Source: Windows SharePoint Services 3 Event Category: Database Event ID: 3760 Date: 1/17/2011 Time: 5:16:16 PM User: N/A Computer: SeverName Description: SQL Database 'SharePoint_Config_cc916547-e57f-4fa9-93da-6586ef1c54be' on SQL Server instance 'ServerName\OfficeServers' not found. Additional error information from SQL Server is included below. Cannot open database "SharePoint_Config_cc916547-e57f-4fa9-93da-6586ef1c54be" requested by the login. The login failed. Login failed for user 'Domain\username'. For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Oh that is due to permission issue on Config Db. Do one thing go to SQL server and check permission on Config DB which is mentioned in error. Delegate "DB Creator" and "Security Admin" permission to Farm admin user on that DB. Also check the same for site content DB. Try to edit any list / Library using farm admin account.Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/

Hi, When I go to SQL Server, go to this domain account which is farm admin, I right click and go to options. Under User Mapping, I choose this particular database and I see that dbowner and public have been selected. If I choose Security Admin, I get the error below TITLE: Microsoft SQL Server Management Studio ------------------------------ Add member failed for DatabaseRole 'db_securityadmin'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.4035.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Add+member+DatabaseRole&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Cannot use the special principal 'dbo'. (Microsoft SQL Server, Error: 15405) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=15405&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ I also see this error below in the Windows Log files which I suspect it may be an issue I described above. A database error occurred. Source: Microsoft OLE DB Provider for SQL Server Code: 1205 occurred 1 time(s) Description: Transaction (Process ID 78) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. Context: Application 'SharedServices1'