You may have seen this sentence in front of your SQL Server Agent in SSMS. and so you can’t start your SQL Server Agent ( maybe only with Network Service account )
You can enable Agent Xp’s in sql server 2005. I think you’d better first create a Login and give proper roles to the user who run this [...]
Archive for the ‘SQL Agent’ Category
How to resolve : Agent XPs disabled
Posted in SQL Agent, SQL Server, Sharepoint, tagged Agent XPs disabled, SQL Server Agent on January 15, 2009 | 2 Comments »
SQL Agent Error after deleting a database in sharepoint !
Posted in SQL Agent, tagged cannot open database, Error 18456, Error 4060, Login failed on October 27, 2008 | Leave a Comment »
Today in the Error Logs of the SQL server Agent I saw many error records that they where all the same in 2 kinds. They were all in one type of the below errors :
SQLServer Error: 18456, Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’. [SQLSTATE 28000]
SQLServer Error: 4060, Cannot open database “My old SSP DB name” requested by [...]
