• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 410
  • Last Modified:

Is there a way user can create/delete a ODBC connection on SQL server without logging into server (via RDP etc)?

Is there a way user can create/delete a ODBC connection on SQL server without logging into server (via RDP etc)?
0
farooqhussain
Asked:
farooqhussain
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
in order to acquire the needed permissions on the box to actually create the DSN entry, you need to log in against the computer, eventually with some third-party tools.
as those DSN entries are either registry based (system dsn entries) or file based (we don't speak about the user entries, which are stored in the logged in user registry hive), both operations can be done remotely.

registry entries are here:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI

the folder where the file dsn entries are, is also given by a registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC File DSN\DefaultDSNDir

hope this helps
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now