If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: SQL Server connection error in Vista

Our server is Windows 2003...Sql server is SQL SERVER2000...I am trying to register this sql server from a local machine...It is showing the erroe

"SQL server registration failed because of the connection failuredisplayed below.Do you wish to register anyway?
SQL Server does not exist or access denied.
ConnectionOpen (Connect()) "

TCP/IP and Named Pipes are the enabled protocols in Both Server and Client network Utilities.

Local machine configuration is

OS- Windows vista Business...
SQL- SQL Server 2000 client

I am able to connect from other local machines which is having windows 2000 as OS.

Also I am able to register from the windows vista machine to another sql server which is having Windows 2000 OS. connection problem is only happening when I am trying to connect to Windows 2003 server.

1. Check the spelling of the server name (you'd be amazed how often this fixes the "problem" for my users).
2. Verify that you can ping the server (no network connectivity, no SQL connectivity)
3. Verify that you can connect to a different SQL Server from the affected machine (if the SQL stack won't connect to any server.... )
4. Try to connect from OSQL.EXE insteas of a GUI tool, it gives much more informative error messages.

If you don't have a working connection at this point, post the results from step 4 so that we can narrow down the search a bit.