sql server connect: Hi All
when i try to register an instance of SQL server sometimes it's registered
successfully and sometimes not, giving me the error SQL server Error:17 SQL
server does not exist or access denied.
I installed service pack 3 and i still get error.
Also when i try to add a Data source, i can do it successfully using named
pipes as the network protocol but it fails with TCP/IP.
Thanks for your help

Reply with the OS error returned while connecting using an ODBC test DSN.
Or test using ISQL.exe from a command prompt.

Example:

ISQL -Stcp:ServerNameHere -Usqluseridhere -Ppasswordhere -Q"select
@@version"
or
ISQL -Stcp:ServerNameHere -E -Q"select @@version"

Search the kb for the OS error returned.
Example:
10060 == Connection Timeout
10061 == Connection Refused. The server is not listening on TCP. This
could be caused if we fail to bind to the port.

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.