New Question
 
 
PRTG Network Monitor

Intuitive to Use.
Easy to manage.

200.000 administrators have chosen PRTG to monitor their network. Find out how you can reduce cost, increase QoS and ease planning, as well.

Free PRTG
Download >>

 

What is this?

This knowledgebase contains questions and answers about PRTG Network Monitor and network monitoring in general. You are invited to get involved by asking and answering questions!

Learn more

 

Top Tags


View all Tags


MS SQL v2 sensor has stopped working

Votes:

0

Your Vote:

Up

Down

We have just upgraded from 15.1.14.1778 to 15.2.16.2230 and out SQL sensors have stopped working - actually all except one.

We have sensors added for our two SQL servers (2008 R2) that run a small SQL script, and they were all working perfectly until we upgraded. On one server we simply get "Timeout PE018" (single instance, multiple databases), but on the other server (multiple instances, multiple databases), one instance is working, the others all fail with messages similar to "Cannot open database "Holdiary" requested by the login. The login failed. Login failed for user 'redacted'.(Connectionstring: Data Source=redacted,1433;Initial Catalog=Holdiary;Integrated Security=True;Password=)".

With a colleague we have discovered the reason, only one instance is on port 1433, the others are dynamic - the sensor is now only using the fixed port for all the instances, so in the last example above it always connects to the same instance regardless of what we define in the sensor and therefore fails. Before the upgrade the sensor was connecting correctly, now it doesn't.

How can we fix this?

sql-server sql-server-login sqlsensor

Created on May 15, 2015 9:03:34 AM by  Fernando Viñan-Cano (0) 1



3 Replies

Votes:

0

Your Vote:

Up

Down

Have you tried to use apexes in the connection string? Data Source='redacted,1433';Initial Catalog=Holdiary;Integrated Security=True;Password=

Created on Jun 30, 2016 3:31:52 PM by  Andrea (216) 1 2



Votes:

0

Your Vote:

Up

Down

No, because at some point later on, PRTG got fixed and the sensors started working again.

Created on Jul 1, 2016 8:45:15 AM by  Fernando Viñan-Cano (0) 1



Votes:

0

Your Vote:

Up

Down

Alright, thanks for the update, Fernando!

Created on Jul 1, 2016 9:12:56 AM by  Stephan Linke [Paessler Support]



Please log in or register to enter your reply.


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.