Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a named instance of MS SQL Server 2008 running on port 1456. TCP/IP and NamedPipes are ENABLED for the server. No Aliases created.

local address: 192.168.1.123\RM - works from local computer and local subnet (no ports specified when connecting)
local name: my-server\RM - works from local computer and local subnet (no ports specified when connecting)
remote address (thru the router): 209.111.111.111,1456\RM - DOES NOT WORK from local or remote networks. I get "login failed" error, all because I hit the DEFAULT instance all the time, which is SQL 2005 (works fine).

Port forwarding on the router is setup. Port 1456 is open.

How do I connect to the server from ANOTHER NETWORK (going thru the router)?

share|improve this question
add comment

1 Answer

up vote 2 down vote accepted

User a tcp/ip connection directly to the port: 209.111.111.111,1456

If you specify the port, do not put \RM at the end.

share|improve this answer
    
it takes me to the DEFAULT INSTANCE that's running on 1434 –  roman m Jul 2 '09 at 18:23
1  
Are your instances set up to use static tcp/ip ports instead of dynamic ones? Are you sure the routers are forwarding the correct source port to the correct destination port? –  NYSystemsAnalyst Jul 2 '09 at 18:40
    
thank you ... the router port forward was forwarding to the wrong port –  roman m Jul 2 '09 at 18:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.