DB Mail issues with DLL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » DB Mail issues with DLL

DB Mail issues with DLL

Rate Topic

Display Mode

Topic Options

Author

Message

Saravanan_tvr

Posted Monday, December 10, 2012 10:07 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Dear All,

I have been facing the problem when I am sending mail , in example in Test mail I am getting the below error

TITLE: Microsoft SQL Server Management Studio
------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
ADDITIONAL INFORMATION:

Mail not queued. Database Mail is stopped. Use sysmail_start_sp to start Database Mail. (Microsoft SQL Server, Error: 14641)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=10.50.1600&EvtSrc=MSSQLServer&EvtID=14641&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

My Server version : Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64)
Apr 2 2010 15:48:46
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)

My OS version : Windows 2008 server r2 64 bit

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1394882

Animal Magic

Posted Tuesday, December 11, 2012 7:09 AM

SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:08 AM
Points: 983, Visits: 13,350

Is your issue that you cant start database mail? Or that you think its started but are still receiving the message you posted?

If you cant start it then please can you post the output of sysmail_start_sp

Post #1395107

Saravanan_tvr

Posted Tuesday, December 11, 2012 9:19 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Yes, I tried to send a test mail from database mail, I am getting the above error, as well
If use the sysmail_start_sp , I didn't get any output --- Just comment completed successfully

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1395414

Bhuvnesh

Posted Wednesday, December 12, 2012 4:01 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

Saravanan_tvr (12/11/2012)

Yes, I tried to send a test mail from database mail, I am getting the above error, as well
If use the sysmail_start_sp , I didn't get any output --- Just comment completed successfully

see the links available here http://msdn.microsoft.com/en-us/library/ms188663(v=sql.105).aspx

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1395568

Saravanan_tvr

Posted Wednesday, December 12, 2012 8:57 PM

SSC Veteran

Group: General Forum Members
Last Login: Thursday, April 25, 2013 7:04 AM
Points: 269, Visits: 1,110

Yes I tried with all but again it says the below error from

SELECT * FROM msdb.dbo.sysmail_event_log;

Results

1) Exception Information
===================
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: SRVEPM
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)

Many Thanks!
S.saravanan
“I am a slow walker, but I never walk backwards-
Abraham Lincoln”

Post #1395965

Mac1986

Posted Wednesday, December 12, 2012 10:18 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:33 AM
Points: 180, Visits: 512

After the Account and the Profile are created successfully, we need to configure the Database Mail. To configure it, we need to enable the Database Mail XPs parameter through the sp_configure stored procedure, as shown here:

sp_CONFIGURE 'show advanced', 1
GO
RECONFIGURE
GO
sp_CONFIGURE 'Database Mail XPs', 1
GO
RECONFIGURE
GO

Post #1395982

« Prev Topic | Next Topic »

Permissions