Event Type: Error
Event Source: Windows SharePoint Services 3
Event ID: 3760
Event Category: Database
Description:
SQL Database ‘SharePoint_Config_’ on SQL Server instance ‘ComputeName\Microsoft##SSEE’ not found. Additional error information from SQL Server is included below.
Cannot open database “SharePoint_Config_” requested by the login. The login failed.
Errors in the Studio Express: Cannot show requested dialog.
ADDITIONAL INFORMATION: Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)
Database ‘SharePoint_Config_’ is already open and can only have one user at a time. (Microsoft SQL Server, Error: 924)
Cannot connect to the configuration database. The database SharePoint_Config_ is not accessible. (Microsoft.SqlServer.Express.ObjectExplorer)
Solution:
1. Change the database mode from Single_User to Multi_User
For SQL Server Express, execute the following query against the database:
ALTER DATABASE
For SQL Server 2005 or 2008:
a. Go to the property of the database.
b. Select Options.
c. Under State, Restricted Access, set the value to MULTI_USER.
2. Open a Command Prompt window and at the command prompt change to the following directory:
%COMMONPROGRAMFILES%\Microsoft shared\Web server extensions\12\Bin
3. At the command prompt, type the following command, and then press ENTER to stop the SPWebService service:
stsadm -o provisionservice -action stop -servicetype spwebservice -servicename “”
4. After the SPWebService service has stopped, type the following command, and then press ENTER to start the SPWebService service:
stsadm -o provisionservice -action start -servicetype spwebservice -servicename “”
5. After the SPWebService service is started, type the following command to complete the hotfix process or the update process:
psconfig -cmd upgrade -inplace b2b -wait -force