Windows Server - sbs 2008 Sharepoint 3.0 Central Administration error: cannot connect to the configuration database

Asked By john doe

08-Feb-10 10:35 AM

On sbs 2008, I am trying to connect to the SharePoint 3.0 Central
administration and it is not working. It gives this error:
Cannot connect to the conguration databse.
This is a test environment.
Please advise and thanks

08-Feb-10 12:17 PM

See if this thread helps
http://social.technet.microsoft.com/Forums/en-US/sharepointgeneral/thread/8b3094a1-31ee-49d7-ab02-72ca0dc440a7
Russ

--
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Second Opinion $25.00 - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com

08-Feb-10 01:57 PM

Russ, that did not help. Here is what the event viewer says:

SQL Database 'SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6' on SQL
Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found.
Additional error information from SQL Server is included below.
Cannot open database
login. The login failed.
Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

08-Feb-10 02:28 PM

Try this
http://msdn.microsoft.com/en-us/library/aa952804(BTS.20).aspx
Russ

--
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Second Opinion - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com

08-Feb-10 04:04 PM

I think the below resolution will fix my problem.  How do I grant the
NETWORK SERVICE account "Database Creation" rights in SQL Server?
Resolution
To resolve this issue, do one of the following:

a.. Grant the NETWORK SERVICE account "Database Creation" rights in SQL
Server.


b.. Change the application pool identity account to an account that has

08-Feb-10 05:31 PM

I cannot find the instructions for the first one.

second one
http://support.microsoft.com/kb/832770


--
Russell Grover - SBITS.Biz [SBS-MVP]
Microsoft Gold Certified Partner
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Second Opinion - www.PersonalITConsultant.com
Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com

09-Feb-10 10:01 AM

Are you sure you need to do this?  Have you installed a SBS rollup
patch?  If not, try that first.

09-Feb-10 11:40 AM

I tried the second one and I get this error message:

TITLE: Microsoft SQL Server Management Studio Express
------------------------------
Create failed for Login 'SERVER\NETWORK SERVICE'.
(Microsoft.SqlServer.Express.Smo)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Login&LinkId=20476------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
User does not have permission to perform this action. (Microsoft SQL Server,
Error: 15247)
For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=15247&LinkId=20476
------------------------------

I tried to check out the links from Microsoft but they did not have any info.
Thanks

09-Feb-10 12:02 PM

Well, I cannot get the Sharepoint 3.0 Central Administration to work on
SBS2008. When I click on it, the webpage comes up and says, "Cannot connect
to the configuration database."

I never heard of a SBS rollup patch.

I cannot believe how hard this stuff is. SBS2003 was a whole lot easier.



Are you sure you need to do this?  Have you installed a SBS rollup
patch?  If not, try that first.

09-Feb-10 08:56 PM

SBS 2003 has/had it is moments too where it broke Sharepoint.

Step one, flip the box over to Microsoft update and ensure you install
SBS update rollup 3 and get this box patched up to snuff before messing
with Sharepoint.

10-Feb-10 11:46 AM

Will do. I will get back with you. Thanks for your help.

10-Feb-10 02:44 PM

Susan, I went to download the rollup from Microsofts web page but they said
to use update.microsoft.com which brings up Windows Update on SBS2008 and it
says that "There are no updates available for your computer" and that is for
online updates also.
Please advise.
Thanks

10-Feb-10 03:13 PM

http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=en-US

Click there.
Ensure that it launches that you are going to Microsoft update.

11-Feb-10 05:55 PM

It still takes me to the Windows Update on the computer and says Windows is
up to date.

11-Feb-10 07:44 PM

Are you positive it says Windows update and does not say Microsoft update
and has a button asking you to flip over to Microsoft update?

Can you email me a screen shot at sbradcpa@pacbell.net?

That should take you to a screen that asks if you want to change Windows
update over to Microsoft update.  Are you using IE?

Can you run www.sbsbpa.com and let me know what it says you are missing
in patches.

In the meantime read these as I think this is your issue:

The Official SBS Blog : Companyweb Inaccessible After Sharepoint 3.0
Service Pack 2:
http://blogs.technet.com/sbs/archive/2009/05/06/companyweb-inaccessible-after-sharepoint-3-0-service-pack-2.aspx

The Official SBS Blog : Authentication Issues Accessing Companyweb from
the Server Itself after 963027 or Windows 2008 SP 2:
http://blogs.technet.com/sbs/archive/2009/04/17/authentication-issues-accessing-companyweb-from-the-server-itself-after-963027.aspx

12-Feb-10 09:30 AM

It finally came through. I think Microsoft was down for a minute.
I will let you know how it goes with Sharepoint 3.0 Central Administration

12-Feb-10 04:35 PM

Well, I get an error installing it. I will send the picture to your email.

16-Feb-10 09:43 AM

Well I could not get the fix working for SBS2008 so I reformatted and started
over again.
Thanks for helping me out.