Event ID: 3760

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 SET MULTI_USER

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

You may also like...