asked on

Sharepoint Sites Down / Event ID 27745 Windows SharePoint Services 3 cannot be found error / SBS 2008

My SharePoint Sites are down for example http://companyweb and my Blackberry BESX Administration.

Running Small Business Server 2008

Log Name: Application
Source: Windows SharePoint Services 3
Date: 09/06/2011 12:02:30
Event ID: 27745
Task Category: General
Level: Error
Keywords: Classic
User: N/A
Computer: xxxxxxxx.local
Description:
The description for Event ID 27745 from source Windows SharePoint Services 3 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

#50071: Unable to connect to the database SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6 on xxxxxx\Microsoft##SSEE. Check the database connection information and make sure that the database server is running.

I have followed most of the many reports of this issue but they mainly relate to a failed MS update that broke SharePoint and does not seem to be my issue.

I can connect to the database via SQL Server Management Studio Express using np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query

This may be relevant. If connecting to companyweb via IE8 I just get a 404. If I try using Firefox I am prompted for a user and password and then get:
HTTP/1.1 200 OK
Server: Microsoft-IIS/7.0
Date: Thu, 09 Jun 2011 11:02:41 GMT
Connection: close

In offering suggestions please don't assume I have tried the obvious. I am completely lost when it comes to the SharePoint Services and SQL in general. As an end user this is an area you never venture into until it breaks!

Many thanks,

Brent

wantabe2

Have you checked the services on the server to make sure the required SP services are running?

fernbreck

ASKER

Yes sorry possibly should have added that. Never know how much info to supply as in the past I've posted everything and then I get less interest as there is just too much to read. I was worried with this one as so many of the threads I found on the Microsoft Forums go unsolved. The ones I found on EE didn't seem to apply.

Another bit of info. I can't run the SharePoint Products and Technologies Configuration Wizard as it errors with an unhandled exception. The first bit of the error is as follows:

Microsoft.SharePoint.SPException: Unable to connect to database. Check database connection information and make sure the database server is running. ---> System.Runtime.InteropServices.COMException (0x81020024): Unable to connect to database. Check database connection information and make sure the database server is running.
at Microsoft.SharePoint.Library.SPRequestInternalClass.PreInitServer(String bstrAbsoluteRequestUrl, String bstrServerRelativeUrl, Int32 lZone, Guid gApplicationId, Guid gSiteId, Guid gDatabaseId, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, Boolean fHostHeaderIsSiteName)
at Microsoft.SharePoint.Library.SPRequest.PreInitServer(String bstrAbsoluteRequestUrl, String bstrServerRelativeUrl, Int32 lZone, Guid gApplicationId, Guid gSiteId, Guid gDatabaseId, String bstrDatabaseServer, String bstrDatabaseName, String bstrDatabaseUsername, String bstrDatabasePassword, Boolean fHostHeaderIsSiteName)

I don't know of any other way to test the connection than through Server Management Studio Express.

I also tried looking in the logs in each of the five C:\Program Files (x86)\Microsoft SQL Server\MSSQL.n\MSSQL\LOG folders but could see nothing there that rang alarm bells.

The only change that has been made by me on the server is an upgrade of McAfee VirusScan 8.8 but I have looked at those logs and can't see anything untoward.

fernbreck

ASKER

Just ran psconfig -cmd upgrade -inplace b2b again in the hope it would work a second time.

C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN>psco
nfig -cmd upgrade -inplace b2b
SharePoint Products and Technologies Configuration Wizard version 12.0.6500.5000
Copyright (C) Microsoft Corporation 2005. All rights reserved.

Performing configuration task 1 of 4
Initializing SharePoint Products and Technologies upgrade...

Successfully initialized SharePoint Products and Technologies upgrade.

Performing configuration task 2 of 4
Initiating the upgrade sequence...

Successfully initiated the upgrade sequence.

Performing configuration task 3 of 4
Upgrading SharePoint Products and Technologies...

Successfully upgraded SharePoint Products and Technologies.

Performing configuration task 4 of 4
Finalizing the SharePoint Products and Technologies configuration...

Successfully completed the SharePoint Products and Technologies configuration.

Total number of configuration settings run: 4
Total number of successful configuration settings: 4
Total number of unsuccessful configuration settings: 0
Successfully stopped the configuration of SharePoint Products and Technologies.
Configuration of the SharePoint Products and Technologies has succeeded.

Unfortunately even though it completes successfully my Sharepoint sites are still down.

David Johnson, CD

try disableing mcaffee and check for its logs for anything of interest it might have had a hit on part of IIS and quarantined or deleted an important file.
some info I'd be interested: The base operating system (server 200?), iis version, sql version.
from the management studio can you browse the sharepoint database?
you might want to look at the logs in files "C:\Program Files\Common Files\MicrosoftShared\Web Server Extensions\12\LOGS\"

fernbreck

ASKER

Many thanks for getting back to me. In answer to your questions:

I've already attempted to disable McAfee and the logs are clear. Also nothing in the Quarantine folder.

I'm running Small Business Server 2008 Premium with the default install of IIS etc. I haven't installed SQL Server and but am using SQL Server Express 2005.

Yes I can connect to the databases using Management Studio and expand Tables etc.

"C:\Program Files\Common Files\MicrosoftShared\Web Server Extensions\12\LOGS\" contain the following:

06/20/2011 22:57:15.52       OWSTIMER.EXE (0x2C1C)       0x57C8      Windows SharePoint Services       General       72la      Critical      #50071: Unable to connect to the database SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6 on xxxxxxx\Microsoft##SSEE. Check the database connection information and make sure that the database server is running.
06/20/2011 22:57:15.52       OWSTIMER.EXE (0x2C1C)       0x57C8      Windows SharePoint Services       General       72la      Critical      #50071: Unable to connect to the database SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6 on xxxxxxx\Microsoft##SSEE. Check the database connection information and make sure that the database server is running.
06/20/2011 22:57:23.02       OWSTIMER.EXE (0x2C1C)       0x5274      Windows SharePoint Services       Database      6f8g      Unexpected      Unexpected query execution failure, error code 14. Additional error information from SQL Server is included below. "[DBNETLIB][ConnectionOpen (ParseConnectParams()).]Invalid connection." Query text (if available): "n/a"
06/20/2011 22:57:23.02       OWSTIMER.EXE (0x2C1C)       0x5274      Windows SharePoint Services       General       72la      Critical      #50071: Unable to connect to the database SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6 on xxxxxxx\Microsoft##SSEE. Check the database connection information and make sure that the database server is running.
06/20/2011 22:57:23.03       OWSTIMER.EXE (0x2C1C)       0x5274      Windows SharePoint Services       E-Mail      6871      Information      The Incoming E-Mail service has completed a batch. The elapsed time was 00:00:00. The service processed 0 message(s) in total.

Is the issue raised in my first post relevant? Why do I get asked for a Username and Password when connecting to a Sharepoint site via Firefox?

fernbreck

ASKER

I've opened a support case with Microsoft. I will report back in the hope that what they find may help someone else in the future.

ASKER CERTIFIED SOLUTION

fernbreck

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fernbreck

ASKER

Microsoft fixed the issue after I opened a support ticket.

Philip Elder

Thanks for posting that.

We hit this problem today but required a few different steps to get to the resolution:

http://blog.mpecsinc.ca/2011/11/sbs-2008-and-sharepoint-errors-3760-and.html

Philip