Twice happened to me when I install and configure windows 2008 64 bit + sql 2008 using 32 bit DSN, my “sqlserveragent” service couldn’t be started and I cant proceed with vCenter installation. No problem with 32 bit DSN creation and same goes to SQL 2008 installation since all services has been configured to run as “NT AUTHORITY\SYSTEM” users.
The error I got is something about “unable to start dependencies program”. However, my sqlserver already started and few changes has been made as below without joice :
- Changed logon user for that service from “NT AUTHORITY\SYSTEM” to other user.
- Add user to SQLSERVER & SQLSERVERAGENT group.
- Changed permission and etc
When I checked the agent log from SQL Server Management Studio, found out “sqlserveragent” was tried to logon as user “NT AUTHORITY\ANONYMOUS LOGON“.
When googled, found out that I just need to create this user in my SSMS and after that, I managed to start sqlserveragent without problem.
Leave a comment