gdspeare
asked on
Send send_dbmail
I'm having some issues with my send_dbmail recently on a SQL2005 server. For some reason, everything is being queued up and but not sent.
My Database Mail XPs run_value = 1
When i run EXEC msdb.dbo.sysmail_help_stat us_sp; the value is STARTED
When I run EXEC msdb.dbo.sysmail_help_queu e_sp @queue_type = 'mail'; the state is INACTIVE.
If i run
exec msdb.dbo.sysmail_stop_sp
exec msdb.dbo.sysmail_start_sp
the state is still INACTIVE.
Troubleshooting ideas?
My Database Mail XPs run_value = 1
When i run EXEC msdb.dbo.sysmail_help_stat
When I run EXEC msdb.dbo.sysmail_help_queu
If i run
exec msdb.dbo.sysmail_stop_sp
exec msdb.dbo.sysmail_start_sp
the state is still INACTIVE.
Troubleshooting ideas?
did u check the configuration of the server i.e. by any chance dbmail property got disabled?
ASKER
Error on the OS:
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Manage ment.SqlIM ail.Server .Common.Ba seExceptio n
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server), connection parameters: Server Name: ., Database Name: msdb
Data: System.Collections.ListDic tionaryInt ernal
TargetSite: Void OpenConnection(Microsoft.S qlServer.M anagement. Common.Sql Connection Info)
HelpLink: NULL
Source: DatabaseMailEngine
StackTrace Information
===================
at Microsoft.SqlServer.Manage ment.SqlIM ail.Server .DataAcces s.Connecti onManager. OpenConnec tion(SqlCo nnectionIn fo ci)
at Microsoft.SqlServer.Manage ment.SqlIM ail.Server .DataAcces s.DataAcce ssAdapter. OpenConnec tion(Strin g dbServerName, String dbName, String userName, String password)
at Microsoft.SqlServer.Manage ment.SqlIM ail.IMailP rocess.Que ueItemProc esser.Proc essQueueIt ems(String dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)
2) Exception Information
===================
Exception Type: System.Data.SqlClient.SqlE xception
Errors: System.Data.SqlClient.SqlE rrorCollec tion
Class: 20
LineNumber: 0
Number: 2
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Data: System.Collections.ListDic tionaryInt ernal
TargetSite: System.Data.ProviderBase.D bConnectio nInternal GetConnection(System.Data. Common.DbC onnection)
HelpLink: NULL
StackTrace Information
===================
at System.Data.ProviderBase.D bConnectio nPool.GetC onnection( DbConnecti on owningObject)
at System.Data.ProviderBase.D bConnectio nFactory.G etConnecti on(DbConne ction owningConnection)
at System.Data.ProviderBase.D bConnectio nClosed.Op enConnecti on(DbConne ction outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlC onnection. Open()
at Microsoft.SqlServer.Manage ment.SqlIM ail.Server .DataAcces s.Connecti onManager. OpenConnec tion(SqlCo nnectionIn fo ci)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
1) Exception Information
===================
Exception Type: Microsoft.SqlServer.Manage
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server), connection parameters: Server Name: ., Database Name: msdb
Data: System.Collections.ListDic
TargetSite: Void OpenConnection(Microsoft.S
HelpLink: NULL
Source: DatabaseMailEngine
StackTrace Information
===================
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
at Microsoft.SqlServer.Manage
2) Exception Information
===================
Exception Type: System.Data.SqlClient.SqlE
Errors: System.Data.SqlClient.SqlE
Class: 20
LineNumber: 0
Number: 2
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Data: System.Collections.ListDic
TargetSite: System.Data.ProviderBase.D
HelpLink: NULL
StackTrace Information
===================
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.ProviderBase.D
at System.Data.SqlClient.SqlC
at Microsoft.SqlServer.Manage
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
someone made a change on the node name that prevented the service from finding it.
ASKER
Thanks for helping me troubleshoot
Here is a troubleshoot-list
http://dbamohsin.wordpress.com/2011/02/04/database-mail-troubleshooting/