Re: connect to remote sql server failed
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
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
"Iter" <Iter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@xxxxxxxxxxxxxxxx
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.
.
Relevant Pages
- Re: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
... I can't see the warning at the moment but my recollection is that is just warns you that the firewall is on and you might have to configure it. ... Since setup doesn't know what you want to do with SQL Server it can't tell if you have configured it correctly. ... How can I get rid of this warning and continue with my installation? ... 135 TCP - SQL Server Integration Services ...
(microsoft.public.sqlserver.setup) - installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
... I am installing default instance of SQL Server 2008 x64 on Windows Vista ... Firewall" generated a warning. ... How can I get rid of this warning and continue with my installation? ... 135 TCP - SQL Server Integration Services ...
(microsoft.public.sqlserver.setup) - Re: SQL Server 2000 SP4 client connection problem
... If you can connect locally using TCP, the SQL Server must be listening on TCP properly. ... And if you see the connection attempts in the log, then TCP/IP must be passing something to SQL Server. ...
(microsoft.public.sqlserver.connect) - Multiple Ports Open for the Same Connection
... "SQL server listening on TCP, TCP, Shared ... It's SQL Server 2000 on a dual-homed W2K DC. ... SQL Sever application is running on the first port using ...
(microsoft.public.sqlserver.connect) - Re: TCP Connectivity Issue
... No firewalling between them though.. ... It's only TCP connectivity on ... When users try to connect to SQL server they get error: ...
(microsoft.public.sqlserver.connect) |
|
