Re: Use Group Policy to set ODBC

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Homepage: www.gruppenrichtlinien.de - deutsch
Blog: gpupdate.spaces.live.com - english
.

Relevant Pages

  • Re: AS400 to Access
    ... I have a vb program that opens an painfully slow ODBC connection to the 400 ... simply do an Insert for each record into our SQL server, ... > and internal employees I think some of the data will be able to be handled ... > adapter then update the Access OLEDB data adapter using the same dataset. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: SQL server vulnerability through ODBC
    ... Look into Application Roles in SQL Server. ... You can grant the necessary select/insert/delete/update privileges to the ... from setting up an ODBC connection or some way in SQL administration to ...
    (microsoft.public.sqlserver.security)
  • Access FE link to two SQL database using ODBC...
    ... I have an Access FE with tables link to two SQL BE using ODBC connection. ... password for the "other" SQL database. ... "trust Connection" and it works. ...
    (microsoft.public.access.forms)
  • Re: Using Projects saved in an ODBC database
    ... This is the first I've heard of anyone saving to a VFP database. ... The documentation I have only mentions SQL Server and Oracle. ... > error when I try to Open from an VFP8 ODBC connection. ...
    (microsoft.public.project)