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
Simon schrieb:
> 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?
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
--------------------------------
Mark
--
Mark Heitbrink - MVP Windows Server - Group Policy
Homepage: www.gruppenrichtlinien.de - deutsch
Blog: gpupdate.spaces.live.com - english
[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?
[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
VALUENAME "Trusted_Connection"
END PART
END POLICY
END CATEGORY
[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
VALUENAME "Trusted_Connection"
END PART
END POLICY
END CATEGORY