server registeration problem...

29 Sep 2005 5:15 PM

=== Steve L ===

Background: sql2k on windows 2k3 servers.

I'm managing an remote offsite sql server for a company.
I recently installed a second instance of sql server (server\dev) on
the same box, but haven't been able to register the 2nd instance
remotely from my laptop. I used mstsc to access server directly and set
up the 2nd instance of sql server and registered it on the remote
server. All worked fine except from my local workstation/laptop, I can
only register the original instance of sql server (by IP, not by the
server name, i don't know why), but not the 2nd instance. (I tried both
sa and windows account with sys admin rights)

Error msg is like

Sql server does not exist or access denied.
Connectionopen(connect())....

The first instance uses port 1433, the 2nd instance uses port 1434. I
checked the firewall settings on remote server to make sure it accepts
my IP and ports. And I make sure Login accounts (set up in mixed mode)
are set up the same on both instances. Can someone tell me what else to
check to make it work?

Thank you.

29 Sep 2005 6:21 PM

Jerry Spivey

Steve,

A shot in the dark - never tried it - but what about IPAddress/InstanceName?

HTH

Jerry
Show quote

"=== Steve L ===" <steve.***@powells.com> wrote in message
news:1128014142.588591.55910@z14g2000cwz.googlegroups.com...
> Background: sql2k on windows 2k3 servers.
>
> I'm managing an remote offsite sql server for a company.
> I recently installed a second instance of sql server (server\dev) on
> the same box, but haven't been able to register the 2nd instance
> remotely from my laptop. I used mstsc to access server directly and set
> up the 2nd instance of sql server and registered it on the remote
> server. All worked fine except from my local workstation/laptop, I can
> only register the original instance of sql server (by IP, not by the
> server name, i don't know why), but not the 2nd instance. (I tried both
> sa and windows account with sys admin rights)
>
> Error msg is like
>
> Sql server does not exist or access denied.
> Connectionopen(connect())....
>
> The first instance uses port 1433, the 2nd instance uses port 1434. I
> checked the firewall settings on remote server to make sure it accepts
> my IP and ports. And I make sure Login accounts (set up in mixed mode)
> are set up the same on both instances. Can someone tell me what else to
> check to make it work?
>
> Thank you.
>

29 Sep 2005 7:18 PM

=== Steve L ===

tried that. no luck.

29 Sep 2005 7:48 PM

ML

Have you tried putting both machines in the same workgroup - I presume you
can't put them in the same domain. (Grasping straws here.)

ML

30 Sep 2005 12:51 AM

Matt Neerincx [MSFT]

Try IP address and port, for example ->

123.123.123.123,1434

--
Matt Neerincx [MSFT]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

Show quote

"=== Steve L ===" <steve.***@powells.com> wrote in message
news:1128021480.947298.22910@g49g2000cwa.googlegroups.com...
> tried that. no luck.
>