Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with SMS_SQL_Monitor

Status
Not open for further replies.

Udir

Technical User
Aug 16, 2001
111
US
I continually get Message ID 601 in the SMS_SQL_MONITOR. It says


Failed to execute SQL command: "sp_addextendedproc 'xp_SMS_notification', 'smsxp.dll'". Check messages from SQL Server.

I changed to Advanced Security yesterday afternoon.

Anyone had this problem or know what might be the problem?

Thanks.
 
Maybe you could take a look at the permissions that the machine account has in Active Directory.

My (limited) understanding is that advanced security will run under the context of the local machine, not the service account
 
Here is the solution just in case anyone else runs into this same problem.

Copy the code that is logged in the SMS event and paste it into the SQL Query Analyiser. Remove the first and last " and then place 'exec' at the first of it.

After I did this, everything on the SMS server started working ok.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top