Create a User DSN from GPOs in Windows Server 2008 R2

  1. Create a DSN in computer from you edit Domain GPOs, use Data Sources (OBDC) Tool.
  2. Add in GPO a New DSN and chose you created DSN. 
    image 
  3. Search in Domain controller a file named DataSources.XML for example:
    \\MyDomain.loc\SysVol\MyDomain.loc\Policies\{1A6B002C-E96E-4EEC-980B-F6EAEF6A4AF3}\User\Preferences\DataSources\DataSources.XML
  4. Open DataSources.XML in NOTEPAD with Administrative privileges and delete RED TEXT, for example:
    <?xml version="1.0" encoding="utf-8"?>
    <DataSources clsid="{380F820F-F21B-41ac-A3CC-24D4F80F067B}"><DataSource clsid="{5C209626-D820-4d69-8D50-1FACD6214488}" name="Test" image="0" changed="2010-08-10 17:08:41" uid="{F377E134-DAE7-4FE3-8366-4C7720F3FE64}" userContext="1" removePolicy="0"><Properties action="C" userDSN="1" dsn="Test" driver="SQL Server" description="" username="" cpassword=""><Attributes><Attribute name="SERVER" value="COBOGSQL02"/><Attribute name="DATABASE" value="EpicorTest904"/><Attribute name="LASTUSER" value="jairoc"/><Attribute name="TRUSTED_CONNECTION" value="Yes"/></Attributes></Properties></DataSource>
    </DataSources>

More Info: Write in Comments.

Comentarios