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 Server’ 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 »
Login failed for user “NT AUTHORITY\ANONYMOUS LOGON”
Posted in Errors, SQL Server, Sharepoint, tagged event ID 3351 on December 3, 2008 | 3 Comments »
On my Sharepoint Server Farm I encountered an error after i joined a new web front end server to it. The event viewer every minute was showing this message :
Source : Windows Sharepoint Services
Category : Database
Event ID : 3351
Description :
SQL database login failed. Additional error information from SQL Server is included below.
Login failed for user [...]
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 [...]
