How do you use cloud databases? Take the survey.
Options

SQL Instance Unreachable

mhickmamhickma Posts: 2 New member
edited May 17, 2018 5:57PM in Redgate Monitor
I have MS SQL 2012, and SQL 2016, not running on default port numbers, machines can be connected via WMI, but the Monitoring tool can not connect to the SQL Instance on these host machines.
Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement. This could be because the pre-login handshake failed or the server was unable to respond back in time. The duration spent while attempting to connect to this server was - [Pre-Login] initialization=14648; handshake=13470;

I can connect to the SQL instance, default instance, via SSMS from my work station using the same credentials, Windows Logon, but not with the Monitoring tool.
Any suggestions as what I may need to look at as to what is blocking the monitoring tool?

Thanks
v/r
Michael


· Share on Twitter

Best Answer

  • Options
    mhickmamhickma Posts: 2 New member
    edited May 17, 2018 6:23PM Answer ✓
    This issue seems to have been resolved by turning on the SQL Server Browser. This service is one that we have been turning off, but is necessary for the Red Gate Monitoring tool.
    · Share on Twitter
Sign In or Register to comment.