Re: SQL2005: Cannot connect error 11001

Odd, because it sounds like this should work. Try starting the SQL Server
Browser Service on the laptop and connecting again, just to see if the port
information is what you think it is. For instance, if you changed the port
but didn't restart, it would still be listening on the old port. With
Browser on, try connecting to the computer_name for the default and
computer_name\SQLEXPRESS for the named instance.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.

"Sue Hoegemeier" <Sue_H@xxxxxxxxxxxxx> wrote in message
news:112k2295qpa5ovldjfvs2rdjbf5i5mq8f4@xxxxxxxxxx
Check the SQL Server error log to verify that it is
listening on the port, IP you specify. Try connecting from
the command line using osql:
osql -S tcp:Laptop\InstanceName, <PortNumber> -E

-Sue

On Tue, 28 Mar 2006 15:04:52 -0800, Stephan (Germany)
<StephanGermany@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Hello,

within my network, one laptop get installed MSSQL2005, all services are
activated, network configuration as follows:

shared memory -- enabled
named pipes -- disabled
TCP/IP -- enabled
VIA -- disabled


For TCP/IP:
Protocol: yes

IP Adresses:
========
IP1 :

enabled = yes
IP address: the one of the laptop
TCP dynamic ports: (blank)
TCP port: I have given a port number

IP2:
besides IP address -- same settings like IP1.
IP address: 127.0.0.1 (local loop)

IP all:
dynamic ports -- (blank)
TCP port: I have given a port number (differnt to the others above)

All services restarted in order to activate the settings.

If I use know a second laptop where SQL Server Management Studio is
installed,
I try to connect as follows:

Login -> Database Engine (server type),
Servername: <IP address of MSSQL laptop above)>,<Portnumber
of
IP ALL>

Connection properties: connect to database (default), network protocol
(TCP/IP)

If I press now the button Connect, the error message appears:
Cannot connect to tcp:<Ip address of MSSQL laptop>,<Portnumber of IP ALL>

An error has occured while establishing a connection to the server. When
connecting to SQL server,2005, the failure may be caused by the fact that
under the default settings SQL Server does not allow remote connection.
(provider: tcp provider, error: 0 - not such host is known). (MS SQL
error:
11001)

I have sent a ping to the MSSQL laptop -- ping is responding.
Trying to check with TELNET <IP address of MSSQL laptop>:<Portnumber of IP
ALL>, the telnet will fail.

I don't know why the host is unknown.
On the MSSQL laptop, SQLexpress and MSSQLSERVER are running as instances.
Is there a special settings necessary because of having a named instance
"MSSQLSERVER" ?

What can be the reason for this?

Firewall is deactivated (windows firewall as well as F-Secure firewall).
nethertheless, in Windows firewall an exception rule already exists for
MSSQLSERVER and the port I'm using in IP ALL. The port number is not the
standard number 1433.

Thanks for any help.
Stephan Hofmann.



.

Loading