<div>
You're welcome, thanks for the points.
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I am trying to create an ODBC connection to a SQL Server 2005 instance on another computer on my LAN. This is a workgroup and IS NOT a domain environment. (I have made connections to SQl Server on LAN machines in a domain environment and it works fine)<br />
<br />
This ODBC connection fails when I try to make it. The IP addresses for machines and DNS Server (Router in this case) are assigned dynamically.<br />
<br />
Does anyone know how to make this connection work?<br />
<br />
Thanks!
</div>
</div>


Hello Experts,

I am trying to create an ODBC connection to a SQL Server 2005 instance on another computer on my LAN. This is a workgroup and IS NOT a domain environment. (I have made connections to SQl Server on LAN machines in a domain environment and it works fine)

This ODBC connection fails when I try to make it. The IP addresses for machines and DNS Server (Router in this case) are assigned dynamically.

Does anyone know how to make this connection work?

Thanks!

You&#39;re welcome, thanks for the points.

SQL Database on Network not accessible via ODBC

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.