Error message of 'profile name is not valid' on SQL agent log

  • Hi,

    I have encountered the following error message on SQL agent log of SQL Server 2008 SP1 with Cumulative Update 5 (10.0.2746.00) on Windows 2008 R2 server:

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

    [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.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStre)

    Above error is occured even though database mail is not enabled.

    Please advise. Thanks.

  • It seems some thing in that job is trying to send an email. You need to identify that and see that it is either suppressed or configure database mail on your server.


    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • Hi Bru,

    Thanks for your reply.

    I configured Database Mail account and profile using Configuration wizard and also I enabled Alert System on SQL Agent to use same profile, but when I try sending Test Email, I got the following error message from Mail log:

    Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException

    Message: The read on the database failed. Reason: Failed to load Msxmlsql.dll.

    Data: System.Collections.ListDictionaryInternal

    TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.QueueItem GetQueueItemFromCommand(System.Data.SqlClient.SqlCommand)

    HelpLink: NULL

    Source: DatabaseMailEngine

    StackTrace Information

    ===================

    at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueItemFromCommand(SqlCommand c)

    at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.QueueDataReader.GetQueueData(Int32 receiveTimeoutSec)

    at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.GetDataFromQueue(DataAccessAdapter da, Int32 lifetimeMinimumSec)

    2) Exception Information

    ===================

    Exception Type: System.Data.SqlClient.SqlException

    Errors: System.Data.SqlClient.SqlErrorCollection

    Class: 16

    LineNumber: 1

    Number: 6610

    Procedure: sp_xml_preparedocument

    Server: SGDB01

    State: 1

    Source: .Net SqlClient Data Provider

    ErrorCode: -2146232060

    Message: Failed to load Msxmlsql.dll.

    Data: System.Collections.ListDictionaryInternal

    TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)

    HelpLink: NULL

    StackTrace Information

    ===================

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

    at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

    at System.Data.SqlClient.SqlDataReader.get_MetaData()

    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader()

    at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.ExecuteReader(SqlCommand command)

    The error still appears even after I copied msxmlsql.dll into C:\Program Files\Microsoft SQL Server\90\Shared and msxmlsql.rll into C:\Program Files\Microsoft SQL Server\90\Shared\Resources\1033 and restart SQL Agent.

  • i also experience ExternalMailQueue is always downs when I try to enable it and having the following error message:

    The activated proc '[dbo].[sp_sysmail_activate]' running on queue 'msdb.dbo.ExternalMailQueue' output the following: 'The service queue "ExternalMailQueue" is currently disabled.'

    Very appreciate on any resolution.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply