Use Group Policy to set ODBC

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Hello all,

We are running a single 2000 domain and currently manually set a db
connection on each client so they can open a connection to SQL 2005.

Is there any way to automate the ODBC connection setup using group policy?

Thanks, Simon
 
Hi,
We are running a single 2000 domain and currently manually set a db
connection on each client so they can open a connection to SQL 2005.
Is there any way to automate the ODBC connection setup using group policy?
Click to expand...

At least one Vista Client, RSAT + GPMC and the new 943729 CSE to
handle it in "native GPO" or you can apply it with a custom ADM Template.

Both solution can not provide SQL Authentication, because the SQL driver
restricts the use of passwords by scripts.

ADM could look like this: Cahnge NameofServer + NameofDatabase
Sample of an SQL Database ODBC Connection
--------------------------------
CLASS MACHINE

CATEGORY "ODBC"

POLICY "ODBC Database"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\NameofDatabase"
PART "Driver:" EDITTEXT
DEFAULT "C:\WINDOWS\System32\SQLSRV32.dll"
VALUENAME Driver
END PART
PART "Server:" EDITTEXT
DEFAULT "NameofServer"
VALUENAME Server
END PART
PART "Database:" EDITTEXT
DEFAULT "NameofDatabase"
VALUENAME Database
END PART
PART "LastUser:" EDITTEXT
DEFAULT "%username%"
VALUENAME LastUser
EXPANDABLETEXT
END PART
PART "Trusted_Connection:" EDITTEXT
DEFAULT "yes"
VALUENAME Trusted_Connection
END PART
END POLICY
END POLICY

POLICY "Data Source Typ of NameofDatabase"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources"
PART "Databasetyp NameofDatabase:" EDITTEXT
DEFAULT "SQL Server"
VALUENAME NameofDatabase
END PART
END POLICY

END CATEGORY
 
I have a problem which is like this. I am trying to create a .adm file from an ODBC connector registry file. The .reg file looks like this:



[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ISTraka]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="SQL"
"Database"="IStraka"
"LastUser"="manager"
"Trusted_Connection"="Yes"

When i use a progarm to convert it the results are:

CLASS MACHINE

CATEGORY "SOFTWARE\ODBC\ODBC.INI\ISTraka"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ISTraka"

POLICY "Driver"
PART "Driver"
EDITTEXT
DEFAULT "C:\WINDOWS\system32\SQLSRV32.dll"
VALUENAME "Driver"
END PART
END POLICY

POLICY "Server"
PART "Server"
EDITTEXT
DEFAULT "SQL"
VALUENAME "Server"
END PART
END POLICY

POLICY "Database"
PART "Database"
EDITTEXT
DEFAULT "IStraka"
VALUENAME "Database"
END PART
END POLICY

POLICY "LastUser"
PART "LastUser"
EDITTEXT
DEFAULT "manager"
VALUENAME "LastUser"
END PART
END POLICY

POLICY "Trusted_Connection"
PART "Trusted_Connection"
EDITTEXT
DEFAULT "Yes"
VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Is this converting correct or is the program wrong?
 
I have a problem which is like this. I am trying to create a .adm file from an ODBC connector registry file. The .reg file looks like this:



[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ISTraka]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="SQL"
"Database"="IStraka"
"LastUser"="manager"
"Trusted_Connection"="Yes"

When i use a progarm to convert it the results are:

CLASS MACHINE

CATEGORY "SOFTWARE\ODBC\ODBC.INI\ISTraka"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ISTraka"

POLICY "Driver"
PART "Driver"
EDITTEXT
DEFAULT "C:\WINDOWS\system32\SQLSRV32.dll"
VALUENAME "Driver"
END PART
END POLICY

POLICY "Server"
PART "Server"
EDITTEXT
DEFAULT "SQL"
VALUENAME "Server"
END PART
END POLICY

POLICY "Database"
PART "Database"
EDITTEXT
DEFAULT "IStraka"
VALUENAME "Database"
END PART
END POLICY

POLICY "LastUser"
PART "LastUser"
EDITTEXT
DEFAULT "manager"
VALUENAME "LastUser"
END PART
END POLICY

POLICY "Trusted_Connection"
PART "Trusted_Connection"
EDITTEXT
DEFAULT "Yes"
VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Is this converting correct or is the program wrong?
 
I have a problem which is like this. I am trying to create a .adm file from an ODBC connector registry file. The .reg file looks like this:



[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ISTraka]
"Driver"="C:\\WINDOWS\\system32\\SQLSRV32.dll"
"Server"="SQL"
"Database"="IStraka"
"LastUser"="manager"
"Trusted_Connection"="Yes"

When i use a progarm to convert it the results are:

CLASS MACHINE

CATEGORY "SOFTWARE\ODBC\ODBC.INI\ISTraka"
KEYNAME "SOFTWARE\ODBC\ODBC.INI\ISTraka"

POLICY "Driver"
PART "Driver"
EDITTEXT
DEFAULT "C:\WINDOWS\system32\SQLSRV32.dll"
VALUENAME "Driver"
END PART
END POLICY

POLICY "Server"
PART "Server"
EDITTEXT
DEFAULT "SQL"
VALUENAME "Server"
END PART
END POLICY

POLICY "Database"
PART "Database"
EDITTEXT
DEFAULT "IStraka"
VALUENAME "Database"
END PART
END POLICY

POLICY "LastUser"
PART "LastUser"
EDITTEXT
DEFAULT "manager"
VALUENAME "LastUser"
END PART
END POLICY

POLICY "Trusted_Connection"
PART "Trusted_Connection"
EDITTEXT
DEFAULT "Yes"
VALUENAME "Trusted_Connection"
END PART
END POLICY

END CATEGORY

Is this converting correct or is the program wrong?
 
Back
Top