sql server connect: Remote connection problems -- sql server connect

Re: Remote connection problems

frederic.nourry NO[at]SPAM gmail.com
1/31/2006 12:47:20 AM

Forgot to mention

xp firewall if off
router will route port 62322 to 1433 (i tried with routing and without
nothing works)

also what would be the correct server name to connect using a different
port ?
servername,port
or
servername:port

thanks

[quoted text, click to view]

Re: Remote connection problems

Rick Byham [MS]
1/31/2006 8:39:35 AM

The "sql does not allow remote connection" error makes me think that you
need to restart SQL Server. It doesn't listen on the new port until
restarted.
Also, you can check the error log to see what port it's listening on.
servername,port should do the trick.
--
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.

[quoted text, click to view]

Re: Remote connection problems

frederic.nourry NO[at]SPAM gmail.com
1/31/2006 8:37:14 PM

Thanks Rick

looking at the event viewer I found that the server is listening to
2414

change to server,2414 worked fine

i noticed that, that is the port configured under IPAll, dynamic ports
in server configuration manager

shouldn't i change the port for ip1 and ip2 ?

thanks now i can work

Re: Remote connection problems

Rick Byham [MS]
2/1/2006 10:54:57 AM

This is a confusing aspect of the tool. If the TCP/IP Properties, Protocol
tab has Listen All as Yes, then the individual settings for IP1 and IP2 are
not necessary. If you want to make do different things, you must first
change Listen All to No, and then change the IP settings.
And since one of the IP addresses is the loopback adapter 127.0.0.1, which
isn't visible over the network, you can ignore that. So right now, it sounds
like you are listening on dynamic ports and it is currently listening on
port 2414. If you stop and restart SQL Server, it might come up on a
different port. If that's a problem, remove the 0 from TCP Dynamic Ports,
and pick a port number you like, and then restart SQL Server.
Sorry this is confusing. SP1 will have some new wording in the help topic to
try and clarify this. (No, I don't know when SP1 will be released. <g>)
--
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.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server connect group.