Petri.com forums Home Forums Start Page Forums Frequently Asked Questions FAQ Member List Members List
Go Back   Petri IT Knowledgebase Forums > Server Operating Systems > SBS 2000 / 2003 / 2008 / 2011
Petri.com is happy to award RicklesP the title of Most Valuable Member !!!
Register Calendar Calendar Search Petri IT Knowledgebase Forums Search Todays Posts Today's Posts Mark Forums Read
Notices

Windows Internal Database Service Account Changed

Windows Internal Database Service Account Changed

this thread has 22 replies and has been viewed 32610 times

Closed Thread
 
Thread Tools Search this Thread Display Modes
  #1  
Old 20th July 2009, 20:31
RaeKWoNCHeF RaeKWoNCHeF is offline
Casual
Casual
 
 Join Date: Jun 2009
  6 month star 12 month star
 Location: Metro Detroit
 Posts: 27
 Reputation: RaeKWoNCHeF is on a distinguished road (10)
Question Windows Internal Database Service Account Changed

Gang,

I accidentally changed the service account credentials for the Windows Internal Database (microsoft##ssee) from "Network Service" to "Local system". Now, I get SharePoint database login failure messages for the configuration database and unknown microsoft##ssee errors in the application event log (I can provide specifics if needed). I tried to change the service back to "Network Service" through the SQL 2005 Configuration Manager, but it won't change back (I receive an error - 0x8007056c WMI Provider Error). I don't even get an option to change it to "Network Service" through "services.msc". I cannot change it to "local service" either otherwise I get the same error. How can I fix this? WSUS seems to still be working fine aside from its web service (event 12032), but my SBSMonitoring invalid TCP/IP configuration messages are back and SharePoint is broken. When I go to http://companyweb now, I get an IIS7 page (the SharePoint config database cannot be loaded)! Please help!


Derek
  #2  
Old 21st July 2009, 22:26
RaeKWoNCHeF RaeKWoNCHeF is offline
Casual
Casual
 
 Join Date: Jun 2009
  6 month star 12 month star
 Location: Metro Detroit
 Posts: 27
 Reputation: RaeKWoNCHeF is on a distinguished road (10)
Default Re: Windows Internal Database Service Account Changed

I edited the "microsoft##ssee" service in the registry and was able to enter the Network Service credentials. The "microsoft##ssee" service now starts as "Network Service"! Most events have been resolved for services other than SharePoint. I still cannot connect to the "companyweb" site. I still get an IIS7 web page. I checked the event viewer again and found event ID 3355:

"Log Name: Application
Source: Windows SharePoint Services 3
Date: 7/21/2009 2:33:50 PM
Event ID: 3355
Task Category: Database
Level: Error
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
Cannot connect to SQL Server. np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query not found. Additional error information from SQL Server is included below.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Event Xml:



3355
2
484
0x80000000000000

190275
Application
SERVER.mydomain.local



np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.



AND THEN AFTER THAT ERROR I RECEIVED THE FOLLOWING:


Log Name: Application
Source: Windows SharePoint Services 3 Search
Date: 7/21/2009 2:51:08 PM
Event ID: 10036
Task Category: Gatherer
Level: Error
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
A database error occurred.

Source: Microsoft OLE DB Provider for SQL Server
Code: 0 occurred 1 time(s)
Description: Timeout expired
Event Xml:



10036
2
3
0x80000000000000

190298
Application
SERVER.mydomain.local





Microsoft OLE DB Provider for SQL Server
0
1
Timeout expired



Any ideas? Thanks, in advance, for your assistance.

D
  #3  
Old 27th July 2009, 18:01
RaeKWoNCHeF RaeKWoNCHeF is offline
Casual
Casual
 
 Join Date: Jun 2009
  6 month star 12 month star
 Location: Metro Detroit
 Posts: 27
 Reputation: RaeKWoNCHeF is on a distinguished road (10)
Default Re: Windows Internal Database Service Account Changed

Gang,

I have not received a response to my question re: repair or restoration of the "Windows Internal Database" in SBS2008. I am receiving the following errors now that the "microsoft##ssee" service has been successfully changed back to "NT Authoity\Network Service":



Source: Microsoft-Windows-Perflib
Date: 7/21/2009 4:37:57 PM
Event ID: 2003
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
The configuration information of the performance library "C:\Windows\system32\sqlctr90.dll" for the "MSSQL$MICROSOFT##SSEE" service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.


Log Name: Application
Source: Windows SharePoint Services 3 Search
Date: 7/23/2009 5:00:21 PM
Event ID: 2442
Task Category: Gatherer
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
The index was paused.

Context: Application 'Search', Catalog 'index file on the search server Search'


Log Name: Application




Log Name: Application
Source: Windows SharePoint Services 3
Date: 7/21/2009 2:33:50 PM
Event ID: 3355
Task Category: Database
Level: Error
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
Cannot connect to SQL Server. np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query not found. Additional error information from SQL Server is included below.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Any ideas on how to resolve these? I don't want to have to restore if at all possible. Please advise and thanks again!

D
  #4  
Old 29th July 2009, 00:30
BigStan BigStan is offline
Junior Member
It's not a coincidence
 
 Join Date: Oct 2005
  6 month star 12 month star
 Posts: 102
 Reputation: BigStan is on a distinguished road (49)
Default Re: Windows Internal Database Service Account Changed

Have you re-run the SharePoint Products and Technologies Configuration Wizard. It fixes a lot of errors. If it fails, make a note of what step it failed on and post the log here as an attachment.

Have you run SQL BPA. Run it against the instance \\.\pipe\mssql$microsoft##ssee\sql\query See what it says about the consistance of your databases.
  #5  
Old 30th July 2009, 18:28
RaeKWoNCHeF RaeKWoNCHeF is offline
Casual
Casual
 
 Join Date: Jun 2009
  6 month star 12 month star
 Location: Metro Detroit
 Posts: 27
 Reputation: RaeKWoNCHeF is on a distinguished road (10)
Default Re: Windows Internal Database Service Account Changed

Quote:
Originally Posted by BigStan View Post
Have you re-run the SharePoint Products and Technologies Configuration Wizard. It fixes a lot of errors. If it fails, make a note of what step it failed on and post the log here as an attachment.

Have you run SQL BPA. Run it against the instance \\.\pipe\mssql$microsoft##ssee\sql\query See what it says about the consistance of your databases.
I ran the wizard with no luck. I am still getting an IIS7 page displayed when the clients visit http://companyweb. I still have the following events on the server related to this issue:

Log Name: Application
Source: SQLBrowser
Date: 7/30/2009 10:45:48 AM
Event ID: 3
Task Category: None
Level: Warning
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
The configuration of the AdminConnection\TCP protocol in the SQL instance SBSMONITORING is not valid.


Log Name: Application
Source: MSSQL$SBSMONITORING
Date: 7/30/2009 10:47:25 AM
Event ID: 17187
Task Category: (4)
Level: Error
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log, look for the informational message that indicates that SQL Server is ready before trying to connect again. [CLIENT: XXX.XXX.XXX.XXX]


Log Name: Application
Source: Windows SharePoint Services 3
Date: 7/30/2009 10:47:36 AM
Event ID: 3355
Task Category: Database
Level: Error
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
Cannot connect to SQL Server. np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query not found. Additional error information from SQL Server is included below.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.


Log Name: Application
Source: Windows SharePoint Services 3
Date: 7/30/2009 10:51:07 AM
Event ID: 3760
Task Category: Database
Level: Error
Keywords: Classic
User: N/A
Computer: SERVER.mydomain.local
Description:
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'.


I then ran the SQL 2005 BPA and received only the following error:

Service [SQLBrowser] on host [] is found to be running under LocalSystem account. We recommend that SQL Server services should not run under LocalSystem account.


This leads me to believe that the service account is wrong for the SQLBrowser service. What should it be? Could this issue cause the problems I am experiencing? WSUS seems to be working fine and its database is also house in the "Microsoft##ssee" "Windows Internal Database" instance. Thanks for your advice and please advise!
  #6  
Old 30th July 2009, 18:44
BigStan BigStan is offline
Junior Member
It's not a coincidence
 
 Join Date: Oct 2005
  6 month star 12 month star
 Posts: 102
 Reputation: BigStan is on a distinguished road (49)
Default Re: Windows Internal Database Service Account Changed

Open SQL Server Management. Connect to \\.\pipe\mssql$microsoft##ssee\sql\query

Expand Security and Logins. Double click on NT Authority/Network Service

Under Server Roles, Public and sysadmin should be checked

Under User Mappings, everything should be checked except the 4 default SQL databases.

Under Status, They should both be enabled.

How do yours look?
  #7  
Old 30th July 2009, 21:09
RaeKWoNCHeF RaeKWoNCHeF is offline
Casual
Casual
 
 Join Date: Jun 2009
  6 month star 12 month star
 Location: Metro Detroit
 Posts: 27
 Reputation: RaeKWoNCHeF is on a distinguished road (10)
Question Re: Windows Internal Database Service Account Changed

Quote:
Originally Posted by BigStan View Post
Under Server Roles, Public and sysadmin should be checked.
Under Server Roles, "dbcreator", "public" and "securityadmin" are checked. There is no check by "sysadmin" at all. I take it there should be?

Quote:
Originally Posted by BigStan View Post
Under User Mappings, everything should be checked except the 4 default SQL databases.
Under user mappings, "master", "model", "msdb" and "tempdb" (the 4 default dbs) are not checked. Everything else is.

Quote:
Originally Posted by BigStan View Post
Under Status, They should both be enabled.
The "grant" radio button is selected under "Permission to connect to database engine" and "Login" is "enabled".

Please advise and thanks for your help!!

D
  #8  
Old 30th July 2009, 21:18
BigStan BigStan is offline
Junior Member
It's not a coincidence
 
 Join Date: Oct 2005
  6 month star 12 month star
 Posts: 102
 Reputation: BigStan is on a distinguished road (49)
Default Re: Windows Internal Database Service Account Changed

Check these settings. Except, where it says "Security accounts" it really means "Service Account"

http://technet.microsoft.com/en-us/l.../cc561047.aspx
  #9  
Old 30th July 2009, 21:23
RaeKWoNCHeF RaeKWoNCHeF is offline
Casual
Casual
 
 Join Date: Jun 2009
  6 month star 12 month star
 Location: Metro Detroit
 Posts: 27
 Reputation: RaeKWoNCHeF is on a distinguished road (10)
Default Re: Windows Internal Database Service Account Changed

I will check the TechNet post settings ASAP.

Then the SQLBrowser service being localsystem is not a problem (per the BPA)?!

Also, not having the "sysadmin" checked is not a problem?!

D
  #10  
Old 30th July 2009, 21:27
BigStan BigStan is offline
Junior Member
It's not a coincidence
 
 Join Date: Oct 2005
  6 month star 12 month star
 Posts: 102
 Reputation: BigStan is on a distinguished road (49)
Default Re: Windows Internal Database Service Account Changed

Quote:
Originally Posted by RaeKWoNCHeF View Post
I will check the TechNet post settings ASAP.

Then the SQLBrowser service being localsystem is not a problem (per the BPA)?!

Also, not having the "sysadmin" checked is not a problem?!

D
Neither of those are problems. That's how mine is set. Except I set my Network Service to Admin a while back because I thought it might be a good idea. Not in response to any error.
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Account Service with restricted privilage? bustanji83 Windows Server 2000 / 2003 / 2003 R2 2 28th March 2009 14:15
SBS2000 - Changed Internal IP bicarus SBS 2000 / 2003 / 2008 / 2011 8 3rd March 2009 17:29
Eventlog SQLDVI errors after Update for Windows Internal Database (KB921896) Lukas SBS 2000 / 2003 / 2008 / 2011 4 13th January 2008 17:05
Which service is using a particular account Akubra Windows Server 2000 / 2003 / 2003 R2 4 30th November 2007 05:32
Ex2003 Internal Pop Account not Identified as Internal Account Smile2me Exchange 2000 / 2003 1 27th June 2007 14:49


All times are GMT +3. The time now is 06:42.

Steel Blue 3.5.4 vBulletin Style ©2006 vBEnhanced
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
 

Valid XHTML 1.0!   Valid CSS!

Copyright 2005 Daniel Petri