Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2007-11-16 : 18:12:54
|
| I changed my server's service account to Domain\sqladmin and the service started successfully. I did the same for SQL Agent but the service starts and stops. In Event Viewer saw this error:SQLServerAgent could not be started (reason: SQLServerAgent must be able to connect to SQLServer as SysAdmin, but '(Unknown)' is not a member of the SysAdmin role).I checked Logins under under security in SSMS and the Domain\sqladmin is a member of SysAdmin roles. What's wrong?Canada DBA |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 01:14:14
|
| Is it local admin? Tried reboot server? |
 |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-19 : 05:38:58
|
| I have the same error! Cant figure it out |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-19 : 05:42:19
|
| Looks like with my error its at a network manager problem. Looks like they have denied access to the login. |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-19 : 06:49:43
|
| Is your hardware profile enabled? Thats what my problem was, I should have spotted it. |
|
|
|
CanadaDBA
583 Posts |
Posted - 2007-11-19 : 13:54:26
|
| I didn't reboot the server but changed both SQL Server and SQL Agent service IDs to Domain\sqladmin. This morning another DBA tried and it started without any problem! I don't know why it didn't started on Friday. Canada DBA |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-19 : 22:50:55
|
| Sever had problem to talk to domain controller. |
|
|
|
|
|
|
SQL Agent does not start