Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thermalnoise
Starting Member
7 Posts |
 Posted - 2006-09-18 : 14:41:24
|
| Our computer admins decided to rename my computer which has caused the SQL2000 Service authentication to fail and the service will not start. It says "The service did not start due to a logon failure." Click OK, then "An error 1069 - (The service did not start due to a logon failure.) occurred while performing this service operation on the MSSQLServer service." According to this article http://support.microsoft.com/kb/303774/ I should run some commands to rename the server to match the machinename. But I can't connect to the server in the first place to do this.I have rerun setup but this didn't work.Any suggestions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-09-18 : 14:45:56
|
| You first need to change the SQL Server service accounts as the error indicates that's the problem. Go to Control Panel, Admin Tools, Services, then find the MSSQLSERVER and SQLSERVERAGENT services. If you are using a named instance, the service names would be MSSQL$NamedInstanceNameGoesHere and SQLAGENT$NamedInstanceNameGoesHere. After that part is resolved, you will indeed need to run those commands.Tara Kizer |
 |
|
|
thermalnoise
Starting Member
7 Posts |
Posted - 2006-09-18 : 16:35:03
|
| Tara, thanks for your reply. You got me back on track! |
|
|
|
|
|
|
PC Renamed, Now SQL2000 service won't start