After I changed my admin password in Windows, my SQL Server Service Manager
(i.e. the Agent) no longer starts up.  How do I fix this?

Go to the Services and changes to Service Account the MSSQL Server and the
Agent logs in, then tr to start up the services as usual, that will work. If
you don´t need any access to the network with the SQL Server Services you
can also change the securty settings to LocalService Account.

But keep the following quote from MS in mind: "Security Note  The
LocalSystem account has elevated local privileges. Enable delegation using a
domain user account whenever possible."


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


Show quoteHide quote

Corrupted table
Null fields (username, host, etc) returned in a trace!?!
Nonpaged pool ? What is it ?
Unknow user name or bad password.
forcing string value in table
Newbie: HELP takes too long for ALTER TABLE!
linked server problem with @@SERVERNAME
Upgrading a W2K3 server with SP4 beta applied
Slow fetches and network buffer size
Regarging the Blank Field in SQL Server