Send send_dbmail

gdspeare
gdspeare used Ask the Experts™
on
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_status_sp; the value is STARTED
When I run EXEC msdb.dbo.sysmail_help_queue_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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
I should look in the in the eventlog

Here is a troubleshoot-list
http://dbamohsin.wordpress.com/2011/02/04/database-mail-troubleshooting/

Commented:
did u check the configuration of the server i.e. by any chance dbmail property got disabled?

Author

Commented:
Error on the OS:


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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server), connection parameters: Server Name: ., 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: 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.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.
Commented:
okay. So, whts the authentication you are using? is it windows or sql one. Again check the password, if in case it was modified for the account you are using to make connection to the sql server.
Also check whether you can access the sql server , the way you are doing for the job.

Author

Commented:
someone made a change on the node name that prevented the service from finding it.

Author

Commented:
Thanks for helping me troubleshoot

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial