1

Closed

Accessing Remote Windows Registry

description

When using SQL Authentication to connect to server. SQL Live Monitor tries to access the registry on the remote server when it doesn't have any credentials to allow the access.
 
Application log is as follows,

 

27/10/2009 11:52:13 AM Application Initialised - Version 1.24.3587.19309
27/10/2009 11:52:38 AM Connecting to Database [SERVERNAME] Using SQL Authentication. Detail not shown for security
27/10/2009 11:53:16 AM Server Version is - 10.0.2531.0 - SP1 - Developer Edition
27/10/2009 11:53:33 AM Server Has AWE Disabled
27/10/2009 11:53:39 AM Accessing Remote Registry on MELM2DBAREP
27/10/2009 11:53:51 AM ERROR Could not access the registry on MELM2DBAREP: Attempted to perform an unauthorized operation.
Closed Nov 3, 2009 at 4:10 PM by glensmall
fixed in version 1,26

comments

glensmall wrote Oct 27, 2009 at 10:06 AM

Ah yes, thanks for this. I had forgotten to document that the current limitation of remote connections, is that it will currently only work in a domain environment , where the current logged-in user has permissions on the remote server.

This is being addressed, and the next version (hopefully) will give you the ability to specify the Windows credentials to use on the remote server - as well as SQL Auth.

glensmall wrote Nov 1, 2009 at 3:35 PM

version 1.26 (currently going through test) has this issue addressed. Now remote registery access will use WMI authenticated calls if the user is using SQL Authentication.

Expect to see beta 1.26 some time next week.