Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:\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):,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
up vote 2 down vote accepted

User a tcp/ip connection directly to the port:,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
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

Your Answer


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.