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 dont 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
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> 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?
>
Showing posts with label starts. Show all posts
Showing posts with label starts. Show all posts
Thursday, February 9, 2012
Admin password
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 dont 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
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> 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?
>
(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 dont 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
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> 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?
>
Admin password
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
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> 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?
>
(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
--
"Uncle Ben" <spamfree@.nospam.com> schrieb im Newsbeitrag
news:%23rzfVXLWFHA.2472@.TK2MSFTNGP10.phx.gbl...
> 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?
>
Subscribe to:
Posts (Atom)