Groups | Blog | Home
all groups > sql server connect > november 2006 >

sql server connect : connect to remote sql server failed



Iter
11/8/2006 1:19:02 PM
I couldn’t connect to the sql server instance (10.192.130.80\development2 and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.
Arnie Rowland
11/8/2006 2:01:55 PM
Can you ping those servers?

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Iter
11/9/2006 5:39:02 AM
Yes, I can Ping them.

[quoted text, click to view]
Kevin3NF
11/9/2006 10:15:15 AM
Is the SQL Server listening on TCP?

Check the SQL ERRORLOG for a line like:

SQL Server listening on tcp, shared memory, named pipes

--
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm

Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com


[quoted text, click to view]

AddThis Social Bookmark Button