<div>
Have you looked at Group Policy Preference &gt;&nbsp;Control Panel Settings &gt;&nbsp;Data Sources &gt;<br />
<br />
From there you can create either a user or system ODBC as you would locally.<br />
<br />
See if that works.
</div>


Have you looked at Group Policy Preference > Control Panel Settings > Data Sources >

From there you can create either a user or system ODBC as you would locally.

See if that works.

<div>
If no port is provided, 1433 will be used for unnamed (default) instances, or if the Browser Service cannot be contacted. You should not need to do anything.
</div>


If no port is provided, 1433 will be used for unnamed (default) instances, or if the Browser Service cannot be contacted. You should not need to do anything.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I require a group policy to connect client to an SQL Server.<br />
<br />
I have configured a &quot;Data Source&quot; item in Group Policy and it configures correctly on the workstations.<br />
<br />
I require the client to use port 1433, server is set up this way, however the group policy object sets up dynamic ports allocation in ODBC connector on the client.<br />
<br />
Does anyone know how I can configure the client to use port 1433 using group policy?<br />
<br />
I do not wish to update each machine individually.
</div>
</div>


Hi,

I require a group policy to connect client to an SQL Server.

I have configured a "Data Source" item in Group Policy and it configures correctly on the workstations.

I require the client to use port 1433, server is set up this way, however the group policy object sets up dynamic ports allocation in ODBC connector on the client.

Does anyone know how I can configure the client to use port 1433 using group policy?

I do not wish to update each machine individually.

How to configure Data Sources via Group Policy

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.