What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general.

Learn more

PRTG Network Monitor

Intuitive to Use. Easy to manage.
More than 500,000 users rely on Paessler PRTG every day. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free Download

Top Tags


View all Tags

Microsoft SQL v2 Sensor Issue "The semaphore timeout period has expired"

Votes:

0

Hi PRTG,

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?

Many thanks

microsoft-sql-v2 prtg sql

Created on Apr 25, 2022 10:29:45 AM



1 Reply

Votes:

0

Hello, we notice this error comes directly from SQL, it is not an error message from PRTG. From our perspective we would suggest to make sure the probe has .net framerwork version 4.7.2. And also we would need to see screenshots of the settings tab of this sensor. You can add the screenshots here or you could send an email to [email protected] with the information so we can take a look.

Created on Apr 28, 2022 11:36:30 PM by Jonathan Mena [Paessler Technical Support]




Disclaimer: The information in the Paessler Knowledge Base comes without warranty of any kind. Use at your own risk. Before applying any instructions please exercise proper system administrator housekeeping. You must make sure that a proper backup of all your data is available.