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

asked 18 Nov '15, 19:10

shaunscott's gravatar image

shaunscott
4821316
accept rate: 16%


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

link

answered 18 Nov '15, 19:29

shaunscott's gravatar image

shaunscott
4821316
accept rate: 16%

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.

link

answered 19 Nov '15, 11:17

Quinn's gravatar image

Quinn ♦♦
14.5k3925
accept rate: 35%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×22
×1

Asked: 18 Nov '15, 19:10

Seen: 4,536 times

Last updated: 19 Nov '15, 11:17