SBS 2008 and Companyweb Offline
ByOver the last couple of weeks, I’ve seen reports of companyweb not displaying on some SBS 2008 servers. Same when trying to load the SharePoint 3.0 Central Administration site. Poking through the event logs, we’re seeing errors and warnings like:
Error Windows SharePoint Services 3 3760 Database
SQL Database ‘ShareWebDb’ 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 "ShareWebDb" requested by the login. The login failed.
Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
Restarting the Windows Internal Database (Microsoft##SSEE) service restores access, at least temporarily.
Thus far, I’ve been unable to identify any commonality that might be triggering this behavior. If you have encountered this issue, especially if all you’ve had to do is restart the Windows Internal Database service to recover access, please post a comment back so we can try to collect additional information and see what might be triggering this issue.
1 Comments
February 25th, 2010 at 5:30 pm
I ran into a very similar problem with the Internal Database and the SBS Console. When trying to add a user to a group, the SBS Console would crash and a Windows Event error would be generated with the following information:
SQL Database ‘ShareWebDb’ 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 “ShareWebDb” requested by the login. The login failed.
Login failed for user ‘MyDomain\myuser’.
After a fair bit of frustrating Googling, I ran across your blog entry and tried just restarting the Internal Database service. The problem went away with no further action necessary.