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
Major Performace problem
Why the update process take so much time??
execure store procedure from Query Analizer
Null fields (username, host, etc) returned in a trace!?!