<div>
On the SQL server side do you have Named Pipes turned off?<br />
<br />
NP depends on constant access to the original DC to keep the SID active. Change it to TCP/IP and see how it goes.
</div>


On the SQL server side do you have Named Pipes turned off?

NP depends on constant access to the original DC to keep the SID active. Change it to TCP/IP and see how it goes.

<div>
But it works fine form the other 2003 app server, wouldn't that setting affect it too?
</div>


But it works fine form the other 2003 app server, wouldn't that setting affect it too?

<div>
Thanks jimpen, named pipes fixed it
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
Got a strange problem with an ODBC connection from an app server to a database on a SQL server. The app server is 2003 server. The DB server is 2008R2 with SQL 2008.<br />
When I create the odbc connection and test it, it works the first time, but then the next connection attempts all fail with the error:<br />
Attempting connection<br />
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.<br />
Disconnecting from server<br />
<br />
A constant ping from the app server shows no dropped packets. <br />
When I try the same odbc from a different app server and the same db server, it connects ok every time.<br />
Any ideas on what might cause this?
</div>
</div>


Hi,
Got a strange problem with an ODBC connection from an app server to a database on a SQL server. The app server is 2003 server. The DB server is 2008R2 with SQL 2008.
When I create the odbc connection and test it, it works the first time, but then the next connection attempts all fail with the error:
Attempting connection
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Disconnecting from server

A constant ping from the app server shows no dropped packets. 
When I try the same odbc from a different app server and the same db server, it connects ok every time.
Any ideas on what might cause this?

Intermittent failed test connections to SQL ODBC

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.