Question

0

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)?

edited Jul 2 at 18:38

asked Jul 2 at 18:11

rm
23●1●5

NYSystemsAnalyst · Answer 1 · 2009-07-02 18:16:41Z

2

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.

answered Jul 2 at 18:16

NYSystemsAnalyst
817●1●6

it takes me to the DEFAULT INSTANCE that's running on 1434 – rm Jul 2 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 at 18:40

thank you ... the router port forward was forwarding to the wrong port – rm Jul 2 at 18:44

How do I connect to NAMED INSTANCE of SqlServer 2008 running on custom port from another network?

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

1 Answer

Your Answer

Not the answer you're looking for? Browse other questions tagged sql-server-2008 ssms2008 sqlservermanagementstudio networking router or ask your own question.

Greetings!

Related