Configure Database Server Monitor window freezing

shaunscott 37
Viewed 0

Just trying to set-up a Database server monitor and with Validate Connection string reads:

Successfully connected to the database. The whole thing then freezes. I then have to close out of PA server monitor and go back in. It also appears my connection sting has changed in the back-ground window:

Driver={SQL Server Native Client 10.0};Server=serverinstance;Trusted_connection=Yes;Database=master;UID=domain???;PWD={hidden};

But it appear to remove the Trusted connection part.

It adds the monitor ok if I use a local SQL user, but then the monitor fails to run with a "remote registry not running" Shaun

database database-monitoring
2 Answers

Further to this I have received this alert, not sure if it is related: System Error Detected: Database error

Failed to get an ODBC statement handle. Error=4294967294, , m_hDBC == NULL

PA Server Monitor Ver 6.0.1 (Build 9)

This System Alert's delivery can be configured in Settings -> System Alerts

shaunscott37

Hi Shaunscott,

The connection string that you are trying to use is not valid. You can't use Trusted_connection with UID and PWD. Try changing your connection string to use either Trusted_connection or UID and PWD to see if that works.

Thanks
Quinn

Please make sure to mark your questions accepted when you have your answer by clicking the gray check mark to the left of the answer.

Quinn2713
Related