Error 1069

I am getting this error when I try to start my service in win xp pro. any
suggestions on how to reslove this?ryan (ryan@.discussions.microsoft.com) writes:
> I am getting this error when I try to start my service in win xp pro. any
> suggestions on how to reslove this?
That is, you get "The service did not start due to a logon failure."
This is because MS SQL Server, like anything else in Windows, needs an
Windows account to run under, and you have configured MS SQL Server to
use an account that does not exist or is locked out, or you have specified
the incorrect password. Or, not unlikely, it was a correct password once,
but you have later changed it.
In any case, right-click My Computer, select Manage. Find the Services
applet. Here look for the MSSQL Server service. Right-click it, choose
Properities, and go to the second Tab, where you can set login information.
If you set LocalSystem, you never have to bother about 1069 again. On
the other hand, if you run as local system, you cannot access networked
resources from SQL Server. (Which you mainly would do with BULK INSERT
or xp_cmdshell.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp