We have a SQL server cluster comprised of 2 servers, with various databases instances on.
- Microsoft Server 2016 - SSMS v 17.9.1 - SQL server v 13.0.5865.1
We are trying to add a Microsoft SQL v2 sensor to monitor a specific database in the cluster. Both SQL servers in the cluster reside in the same location as the core PRTG server
We have a local SQL user with RO permissions to the specific database, and the Microsoft SQL v2 sensor inherits the credential information from the SQL settings above.
When adding the sensor though, we get this error:
"A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)"
My initial thinking was a connectivity issue between PRTG and the SQL cluster (firewall issue etc hence the semaphore message), but they are in the same location.
Do you have any suggestions for this error?