On SQL 2005 SP1 and getting the following messages each time we start
SQL Agent, yet the test email works. Curious to know if MS Outlook or a
mail profile is required on a database server running SQL 2005.
Currently this server does not have outlook installed on it.



Message

[355] The mail system failed to initialize; check configuration settings



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(TdsParserStateO
bject stateObj)

a)



Message

[364] The Messenger service has not been started - NetSend notifications
will not be sent



Thanks



Jeff




MS Sql Server LazyDBA home page