<div>
Almost appears to be a DNS resolution issue.<br />
<br />
Do the W2K machines only point to your DNS? &nbsp;Are you using a HOSTS file that has bad info in it?<br />
<br />
Has the ODBC connection object been set correctly in ODBC applet?<br />
<br />

</div>


Almost appears to be a DNS resolution issue.

Do the W2K machines only point to your DNS?  Are you using a HOSTS file that has bad info in it?

Has the ODBC connection object been set correctly in ODBC applet?



<div>
try upgrading ODBC connector on workstations..
</div>


try upgrading ODBC connector on workstations..

<div>
Can you post your finding please?<br />
<br />
SC
</div>


<div>
Thanks very much for your input. I reinstalled the latest version of MDAC which solved the issue.
</div>


Thanks very much for your input. I reinstalled the latest version of MDAC which solved the issue.

<div>
Good. Thanks for reverting.<br />
<br />
SC
</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I keep getting the following error (on W2K PC's ONLY) when trying to start a 3rd party program. <br />
Coonection Failed:<br />
SQLState: '01000'<br />
SQL Server Error: 11001<br />
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(get<wbr />hostbyname<wbr />()().<br />
Connection Failed<br />
SQL State: '08001'<br />
SQL Server Error: 11<br />
[Microsoft]ODBC SQL Server Driver][TCP/IP Sockets]General network error. check your network documentation.<br />
<br />
SQL Server Express 2005 is running on a W2K3 server. The XP clients are able to connect without any issues. <br />
<br />
Appreciate your help. 
</div>
</div>


Hi, 

I keep getting the following error (on W2K PC's ONLY) when trying to start a 3rd party program. 
Coonection Failed:
SQLState: '01000'
SQL Server Error: 11001
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(gethostbyname()().
Connection Failed
SQL State: '08001'
SQL Server Error: 11
[Microsoft]ODBC SQL Server Driver][TCP/IP Sockets]General network error. check your network documentation.

SQL Server Express 2005 is running on a W2K3 server. The XP clients are able to connect without any issues. 

Appreciate your help. 

Unable to connect to SQL Server databse - ONLY ON W2K PC's

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.

Microsoft SQL Server 2005

Operating systems perform basic tasks, such as recognizing input from the keyboard, sending output to the display screen, keeping track of files and directories on the disk, and controlling peripheral devices such as disk drives and printers. For large systems, the operating system makes sure that different programs and users running at the same time do not interfere with each other. The operating system is also responsible for security, ensuring that unauthorized users do not access the system. Operating systems provide a software platform on top of which other programs, called application programs, can run.

Operating Systems

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).