dileepggvr
Starting Member
India
2 Posts |
Posted - 12/03/2013 : 04:28:47
|
Databasemail error in clustered environment All the test mails are in external queue And I can send mails from other instance of this cluster
Event Type: Error Event Source: DatabaseMail Event Category: None Event ID: 0 Date: 27-08-2010 Time: 10:01:23 User: N/A Computer: <My_servername> Description:
1) Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException Message: There was an error on the connection. Reason: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified), connection parameters: Server Name: <My_servername>\<My_named_instance>, Database Name: msdb Data: System.Collections.ListDictionaryInternal TargetSite: Void OpenConnection(Microsoft.SqlServer.Management.Common.SqlConnectionInfo) HelpLink: NULL Source: DatabaseMailEngine
StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.OpenConnection(SqlConnectionInfo ci) at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.OpenConnection(String dbServerName, String dbName, String userName, String password) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.QueueItemProcesser.ProcessQueueItems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)
2) Exception Information =================== Exception Type: System.Data.SqlClient.SqlException Errors: System.Data.SqlClient.SqlErrorCollection Class: 20 LineNumber: 0 Number: -1 Procedure: NULL Server: State: 0 Source: .Net SqlClient Data Provider ErrorCode: -2146232060 Message: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) Data: System.Collections.ListDictionaryInternal TargetSite: System.Data.ProviderBase.DbConnectionInternal GetConnection(System.Data.Common.DbConnection) HelpLink: NULL
StackTrace Information =================== at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.ConnectionManager.OpenConnection(SqlConnectionInfo ci)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp
***************************************
Tried the below links, but no luck
_http://blogs.msdn.com/b/sqlserverfaq/archive/2010/03/18/database-mail-failing-with-the-service-queue-externalmailqueue-is-currently-disabled-message.aspx _http://technet.microsoft.com/en-us/library/ms187540(v=sql.105).aspx
I have checked both OS and SQL version and build number; Both are same when comparing it with the other instance on that cluster. SQL2005; productversion:- 9.00.5000.00; productlevel:- SP4; SQLedition :- Enterprise Edition (64-bit) OS:- Windows 2003 SP2
DGGVRDBA |
|