[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1517
  • Last Modified:

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
0
PROJHOPE
Asked:
PROJHOPE
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
this is a know bug in SP1, you need to instal SQL Server 2005, SP2
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now