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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 MSSQLServer service will not start

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-10-08 : 09:52:22
EFadul writes "I've had to reboot the box (Windows NT SP 6) that houses SQL Server 7.0. It probably has been 3 months since the last reboot. During the reboot, an NT message that 'a service failed to start' is displayed. When I try to manually start MSSQLServer using control panel/services, the message 'Error 1069 (The service did not start due to a logon failure)'. There are no other logons in the machine aside from the one used when SQL Server was installed.

Any ideas?

Thanks,
Ed

ps
os: Windows NT SP 6"

1fred
Posting Yak Master

158 Posts

Posted - 2002-10-08 : 10:23:25
Be sure the user is in the administrator group.

Go to Top of Page

Kevin Snow
Posting Yak Master

149 Posts

Posted - 2002-10-08 : 12:26:29
If your passwords expire every couple of months, try reentering the password on the account. Go to Services, click properties for the Microsoft SQL Server service, and check the logon tab. There are entry fields for an account and password. Assuming this option is used, the password has to be manually updated everytime the NT account expires and demands a new password.
Go to Top of Page
   

- Advertisement -