Security problems in SQL 2008 R2 management studio
Posted on 2011-03-02
I have been setting up two new SQL 2008 R2 x64 Servers on Windows Server 2008 x64 boxes in a remote data centre. All was well until the last weekend. I had been adding maintenance plans and jobs but when looked in early this week I noted no jobs had been running. It seems the SQL Agent is suddenly unable to connect to the server and the service will not start. There are numerous login failures for 'NT AUTHORITY\ANONYMOUS LOGON', where this came into the picture i don't know, the Agent service is assigned to the Local System Account. I got the service to run by adding the server name to the registry under the SQL Agent key, but this didn't solve any of the login issues. Plenty of people seem to have had this issue but none of scenarios quite fit this one. The SQL service is running ok and it is a default server instance. Anybody dealt with this before?