Red Gate forums :: View topic - Connection failed for (local)
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 3
SQL Monitor 3 forum

Connection failed for (local)

Search in SQL Monitor 3 forum
Post new topic   Reply to topic
Jump to:  
Author Message
webrunner



Joined: 19 Apr 2011
Posts: 13

PostPosted: Wed Jul 09, 2014 12:50 am    Post subject: Connection failed for (local) Reply with quote

Hello experts,

I want to know the possible causes of this scenario, and how it can be fixed.

1. I am running SQL Monitor 3.3.
2. We recently upgraded two servers from SQL 2008 R2 to SQL 2012.
3. One of the servers is monitoring correctly.
4. The other server, however, has the following issue:
4.1. Under Configuration > Monitored servers, under the server name, it shows "Monitoring Connected"
4.2. Under the (local) section, though, it shows "Connection failed Cannot connect"

Does anyone know why SQL Monitor 3.3 would be able to connect to the server name but not to the (local) instance? I tried running the WMI test at this link
http://www.red-gate.com/MessageBoard/viewtopic.php?t=17415&highlight=local+connection+failed

and it worked when tested from my SQL Monitor server to the server being monitored. But even though I re-enter my credentials or Retry the connection, the situation remains the same - monitoring connected for the server, but connection failed for the (local) section.

Thanks in advance for any help.

- webrunner
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu Jul 10, 2014 12:06 pm    Post subject: Reply with quote

Thank you for your post.

If you navigate back to the Configuration > Monitored Servers page, and then next to the instance showing "Connection failed Cannot connect" you should see a grey symbol indicating an Actions menu. On this menu can you select Show Log.

What are the Exception messages displayed?
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
webrunner



Joined: 19 Apr 2011
Posts: 13

PostPosted: Thu Jul 10, 2014 2:57 pm    Post subject: Connection failed for (local) Reply with quote

Hello chriskelly,

Thank you so much for your reply. The log information is posted below.

- webrunner

Date Group Event Outcome Exception Exception message
10 Jul 2014 9:55 AM SQL GetUtcServerTimeAndProcessId Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL GetVersion Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL GetErrorLogPath Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL #4Jv Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL #nKv Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL #IKv Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL #LVG Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL Database Custom Metrics - fetching online databases Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL #7Jv Cannot connect SqlException 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)
10 Jul 2014 9:55 AM SQL Ping Cannot connect SqlException 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)
10 Jul 2014 9:52 AM SQL #2Kv Cannot connect SqlException 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)
Back to top
View user's profile Send private message
chriskelly



Joined: 19 Apr 2010
Posts: 330
Location: Cambridge, UK

PostPosted: Thu Jul 10, 2014 3:43 pm    Post subject: Reply with quote

Thank you for your reply.

All the exceptions involve the same SQL error 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)

Can you confirm whether you are able to connect to the SQL Server instance using SSMS? For this to be an indicative test, the SSMS should be on the same machine that you installed the SQL Monitor Base Monitor service, and you should use the same instance name and user account that you have specified for the connection.
_________________
Chris Kelly
Technical Support Engineer
Back to top
View user's profile Send private message
webrunner



Joined: 19 Apr 2011
Posts: 13

PostPosted: Thu Jul 17, 2014 4:32 pm    Post subject: Reply with quote

Thank you, Chris, for your reply.

I am looking into this now and will reply with results once I have installed SSMS on the monitoring server and tried the steps you recommended.

- webrunner
Back to top
View user's profile Send private message
webrunner



Joined: 19 Apr 2011
Posts: 13

PostPosted: Fri Jul 18, 2014 4:37 pm    Post subject: Reply with quote

Hello again, Chris,

With help from my systems team I was able to test the connection via SSMS and figure out that it was a firewall issue. You can close out this issue as resolved.

Thanks again,
webrunner
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group