Create a User DSN from GPOs in Windows Server 2008 R2
- Create a DSN in computer from you edit Domain GPOs, use Data Sources (OBDC) Tool.
- Add in GPO a New DSN and chose you created DSN.
- 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 - 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