PROJHOPE
asked on
SQL Server Agent errors in Error log
We are on SQL 2005 SP1 on Windows 2003 SP1 environment. Since installation and establishment of SQL mail we constantly get these error messages in the SQL Server Agent error log. I googled and the only thing I can find is for the version prior the 'go live' of SQL 2005.
Message
[298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_noti fy'. [SQLSTATE 42000] (DisableAgentXPs)
Message
[260] Unable to start mail session (reason: Microsoft.SqlServer.Manage ment.SqlIM ail.Server .Common.Ba seExceptio n: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlE xception: profile name is not valid
at System.Data.SqlClient.SqlC onnection. OnError(Sq lException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlI nternalCon nection.On Error(SqlE xception exception, Boolean breakConnection)
at System.Data.SqlClient.TdsP arser.Thro wException AndWarning (TdsParser StateObjec t stateObj)
a)
Message
[355] The mail system failed to initialize; check configuration settings
Message
[298] SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_noti
Message
[260] Unable to start mail session (reason: Microsoft.SqlServer.Manage
at System.Data.SqlClient.SqlC
at System.Data.SqlClient.SqlI
at System.Data.SqlClient.TdsP
a)
Message
[355] The mail system failed to initialize; check configuration settings
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.