Archive for the ‘SQL Server’ Category

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 service ( in my case Network Service with sysadmin role ). Then  run the below query in management studio to enable agent xp’s.

sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Agent XPs', 1;
GO
RECONFIGURE
GO

Use the Agent XPs option to enable the SQL Server Agent extended stored procedures on the server. When this option is not enabled, the SQL Server Agent node is not available in SQL Server Management Studio Object Explorer.

When you use the SQL Server Management Studio tool to start the SQL Server Agent service, these extended stored procedures are enabled automatically.

Management Studio Object Explorer does not display the contents of the SQL Server Agent node unless these extended stored procedures are enabled regardless of the SQL Server Agent service state.

The possible values are:

  • 0, indicating that SQL Server Agent extended stored procedures are not available (the default).
  • 1, indicating that SQL Server Agent extended stored procedures are available.

The setting takes effect immediately without a server stop and restart. You can find more about SQL Server Agent and Agent XPs option here.

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 ‘NT AUTHORITY\ANONYMOUS LOGON’.

According to the Source of the problem, It thought that it should be related to sharepoint not SQL. I searched a little and found that It’s because of Windows Sharepoint Services Timer. Yes this service had started but the Log On As had been set to Local Service. you know that It should be your Sharepoint Administrator Account. So I changed it ( I mean that both servers should have same Log On As ) and the error stoped.

hope this help ! 🙂