(Msg. 1) Posted: Wed Apr 23, 2008 1:48 pm
Post subject: Use Group Policy to set ODBC Add to elertz Archived from groups: microsoft>public>win2000>group_policy (more info?)
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?
(Msg. 2) Posted: Thu Apr 24, 2008 4:28 pm
Post subject: Re: Use Group Policy to set ODBC Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Hi,
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
(Msg. 3) Posted: Wed Jun 11, 2008 11:23 pm
Post subject: Reply Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
(Msg. 4) Posted: Wed Jun 11, 2008 11:23 pm
Post subject: Reply Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
(Msg. 5) Posted: Wed Jun 11, 2008 11:23 pm
Post subject: Reply Add to elertz [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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:
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Search
Profile
Private Messages
Log in/Register/Password
Windows Other