Start Free Trial
Come for the solution, stay for everything else.
Start Free Trial
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
the state is still INACTIVE.
Microsoft SQL Server 2005
Microsoft SQL Server 2008
8/22/2022 - Mon
I should look in the in the eventlog
Here is a troubleshoot-list
did u check the configuration of the server i.e. by any chance dbmail property got disabled?
Error on the OS:
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
TargetSite: Void OpenConnection(Microsoft.S
g dbServerName, String dbName, String userName, String password)
dbName, String dbServerName, Int32 lifetimeMinimumSec, LogLevel loggingLevel)
2) Exception Information
Exception Type: System.Data.SqlClient.SqlE
Source: .Net SqlClient Data Provider
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)
ction outerConnection, DbConnectionFactory connectionFactory)
For more information, see Help and Support Center at
Your help has saved me hundreds of hours of internet surfing.
ASKER CERTIFIED SOLUTION
Log in or sign up to see answer
Become an EE member today
7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
someone made a change on the node name that prevented the service from finding it.
Thanks for helping me troubleshoot
Plans and Pricing
Certified Expert Program
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent