Cannot connect to SQL Server 2005 from Vista Client

bvsimmons1204 · Post by **bvsimmons1204** » Sun 12 Nov 2006 22:16

I have a applictaion using Version: 3.80.0.33 31.10.06 for SDAC with Delphi 7 and I am unable to establish connection to SQL Server 2000 or 2005 from Vista RC2 Ultimate. The Error message that I a getting is:

[DBNETLIB]Connection Open (Connect()).]SQL Server does not exist.

I am able to make create a ODBC Connection from the Vista Client to either SQL Server 2005 or SQL Server 2000.

Any help would be appreciated as to what I am doing wrong.

Thanks

Bernard

Jackson · Post by **Jackson** » Mon 13 Nov 2006 13:11

It's possible that the problem is in your firewall settings.
Disable your firewall and try again.
Can you establish the connection using ADO (with Microsoft OLE DB Provider for SQL Server)?

bvsimmons1204 · Post by **bvsimmons1204** » Mon 13 Nov 2006 14:59

Thanks for the quick response....

The Vista firewall does not appear to be the problem.
The firewall for the SQL Server 2005 system was disabled for all tests.
I did the following:

Client: Vista RC2 - Server: SQL Server 2000 (WinXP)

Connect via ADO (with Microsoft OLE DB Provider for SQL Server) - OK
Create ODBC Connection - OK
Simple program using SDAC to Connect - OK
(These tests above worked with and with out the Vista Firewall enabled)

Client: Vista RC2 - Server: SQL Server 2005 (WinXP)

Connect via ADO (with Microsoft OLE DB Provider for SQL Server) - Failed
Create ODBC Connection - Failed
Simple program using SDAC to Connect - Failed

Client: Windows XP2 - Server: SQL Server 2005 (WinXP)

Connect via ADO (with Microsoft OLE DB Provider for SQL Server) - Failed
Create ODBC Connection - Failed

Since I am having a complete failure connecting to SQL 2005 from XP or Vista. I will re-install SQL server 2005 and post the results back. I think the problem may be with the fact that I re-named the SQL 2005 Server System.

Thanks again.

bvsimmons1204 · Post by **bvsimmons1204** » Mon 13 Nov 2006 16:32

Found the Problem.... TCP/IP Protocol was not enabled on my SQL Server 2005....

Open "SQL Server Configuration Manager",

- expand the "SQL Server 2005 Network Configuration" node

- select "Protocols for MSSQLSERVER"

- enable "TCP/IP" if it's not already enabled and restart MSSQLSERVER service

The solution was posted at:
http://forums.microsoft.com/TechNet/Sho ... &SiteID=17

Thanks again...