InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 12:36:34 GMT20http://www.sqlservercentral.com/Forums/Topic1394882-1550-1.aspxAfter 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', 1GORECONFIGUREGOsp_CONFIGURE 'Database Mail XPs', 1GORECONFIGUREGOWed, 12 Dec 2012 22:18:50 GMTMac1986http://www.sqlservercentral.com/Forums/Topic1394882-1550-1.aspxYes 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.BaseExceptionMessage: The read on the database failed. Reason: Failed to load Msxmlsql.dll.Data: System.Collections.ListDictionaryInternalTargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.QueueItem GetQueueItemFromCommand(System.Data.SqlClient.SqlCommand)HelpLink: NULLSource: DatabaseMailEngineStackTrace 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.SqlExceptionErrors: System.Data.SqlClient.SqlErrorCollectionClass: 16LineNumber: 1Number: 6610Procedure: sp_xml_preparedocumentServer: SRVEPMState: 1Source: .Net SqlClient Data ProviderErrorCode: -2146232060Message: Failed to load Msxmlsql.dll.Data: System.Collections.ListDictionaryInternalTargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)HelpLink: NULLStackTrace 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)Wed, 12 Dec 2012 20:57:19 GMTSaravanan_tvrhttp://www.sqlservercentral.com/Forums/Topic1394882-1550-1.aspx[quote][b]Saravanan_tvr (12/11/2012)[/b][hr]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 [/quote] see the links available here [url]http://msdn.microsoft.com/en-us/library/ms188663(v=sql.105).aspx[/url]Wed, 12 Dec 2012 04:01:27 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1394882-1550-1.aspxYes, 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 Tue, 11 Dec 2012 21:19:34 GMTSaravanan_tvrhttp://www.sqlservercentral.com/Forums/Topic1394882-1550-1.aspxIs 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_spTue, 11 Dec 2012 07:09:01 GMTAnimal Magichttp://www.sqlservercentral.com/Forums/Topic1394882-1550-1.aspxDear 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 Mon, 10 Dec 2012 22:07:50 GMTSaravanan_tvr