Link to home
Start Free TrialLog in
Avatar of PROJHOPE
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_notify'. [SQLSTATE 42000] (DisableAgentXPs)

Message
[260] Unable to start mail session (reason: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException: Mail configuration information could not be read from the database. ---> System.Data.SqlClient.SqlException: profile name is not valid
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   a)

Message
[355] The mail system failed to initialize; check configuration settings
ASKER CERTIFIED SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial