sql server connect: Just installed SQL Server 2000. However when I ty to start it gives me the
error message: The sevice did no start due to a log on failure. "An error
1069 occured while performing this service operation on the MSSQLServer
service." I am running XP Pro with SP2 installed. Need some help please.
--

Hi,


It seems the password or user in SQL Server service startup account is
having issues.


What to do:-


1. Go to control panel -- Administrative - tools
2. Double click in services icon
3. Select and double click the MSSQL Server service
4. In the "Log on " tab, Check the this account
5. There you verify the OS user name
6. If the user name is correct , re- enter the password and confrim password
once again
7. CLick OK
8. Start the service


Do the above steps for SQL Agent service as well.


Note:


ON each password change you have to do the above steps. The best
recommendation to have a user name for MSSQL server service startup which do
not change password frequently or no password expiry is set.


Thanks
Hari

SQL Server MVP

[quoted text, click to view]