I have a server that has SQL 7.0 installed and a named instance of SQL 2000.
I can easily reference the named instance internally using the following
connect string.

Server=TESTSQL1\SQL2K;

Normally I would connect to a default instance of 2000 using a connection
from outside the firewall over IP as ...

Server = 10.1.1.24

How can I reference a named instance over IP?

The web server is not part of the domain. Is it as simple as using the same
IP address with a different port (other than 1433)?

Thanks

Report this post to a moderator

Server=10.1.1.24\SQL2K

Or use the Client Network Utility to create an alias.

Now, with the firewall you may have a more complicated scenario. Normally
the port number for non-default instances is assigned dynamically. But for
a firewall you'll want to make it static, which you can do with the Server
Network Utility. Then, on the Client, use the Client Network Utility to
define an alias with the static port number. Open up your firewall for that
port. And away you go.


"Mike" <mike528@enteract.com> wrote in message
news:uCTp6ijbCHA.2464@tkmsftngp11...
> I have a server that has SQL 7.0 installed and a named instance of SQL
2000.
> I can easily reference the named instance internally using the following
> connect string.
>
> Server=TESTSQL1\SQL2K;
>
> Normally I would connect to a default instance of 2000 using a connection
> from outside the firewall over IP as ...
>
> Server = 10.1.1.24
>
> How can I reference a named instance over IP?
>
> The web server is not part of the domain. Is it as simple as using the
same
> IP address with a different port (other than 1433)?
>
> Thanks
>
>

Report this post to a moderator

Thanks Hal.

Do you know if I can install and use the clietn utility on a web server
without loading the SQL client tools? Or can I define the connection string
like Server=10.1.1.24\SQL2K;nnnn where nnnn is the assigned port number.

Thanks


"Hal Berenson" <Hal_Berenson@despammed.com> wrote in message
news:efmST#jbCHA.2424@tkmsftngp09...
> Server=10.1.1.24\SQL2K
>
> Or use the Client Network Utility to create an alias.
>
> Now, with the firewall you may have a more complicated scenario. Normally
> the port number for non-default instances is assigned dynamically. But
for
> a firewall you'll want to make it static, which you can do with the Server
> Network Utility. Then, on the Client, use the Client Network Utility to
> define an alias with the static port number. Open up your firewall for
that
> port. And away you go.
>
>
> "Mike" <mike528@enteract.com> wrote in message
> news:uCTp6ijbCHA.2464@tkmsftngp11...
> > I have a server that has SQL 7.0 installed and a named instance of SQL
> 2000.
> > I can easily reference the named instance internally using the following
> > connect string.
> >
> > Server=TESTSQL1\SQL2K;
> >
> > Normally I would connect to a default instance of 2000 using a
connection
> > from outside the firewall over IP as ...
> >
> > Server = 10.1.1.24
> >
> > How can I reference a named instance over IP?
> >
> > The web server is not part of the domain. Is it as simple as using the
> same
> > IP address with a different port (other than 1433)?
> >
> > Thanks
> >
> >
>
>

Report this post to a moderator

I believe the client network utility comes with MDAC, so it should be
present on any system newer than Windows ME (e.g., W2K, Windows XP).
Having MDAC 2.7 on the system is probably best.

As for the connect string question, I don't know the answer.

"Mike" <mike528@enteract.com> wrote in message
news:eHtRzNlbCHA.2144@tkmsftngp12...
> Thanks Hal.
>
> Do you know if I can install and use the clietn utility on a web server
> without loading the SQL client tools? Or can I define the connection
string
> like Server=10.1.1.24\SQL2K;nnnn where nnnn is the assigned port number.
>
> Thanks
>
>
> "Hal Berenson" <Hal_Berenson@despammed.com> wrote in message
> news:efmST#jbCHA.2424@tkmsftngp09...
> > Server=10.1.1.24\SQL2K
> >
> > Or use the Client Network Utility to create an alias.
> >
> > Now, with the firewall you may have a more complicated scenario.
Normally
> > the port number for non-default instances is assigned dynamically. But
> for
> > a firewall you'll want to make it static, which you can do with the
Server
> > Network Utility. Then, on the Client, use the Client Network Utility to
> > define an alias with the static port number. Open up your firewall for
> that
> > port. And away you go.
> >
> >
> > "Mike" <mike528@enteract.com> wrote in message
> > news:uCTp6ijbCHA.2464@tkmsftngp11...
> > > I have a server that has SQL 7.0 installed and a named instance of SQL
> > 2000.
> > > I can easily reference the named instance internally using the
following
> > > connect string.
> > >
> > > Server=TESTSQL1\SQL2K;
> > >
> > > Normally I would connect to a default instance of 2000 using a
> connection
> > > from outside the firewall over IP as ...
> > >
> > > Server = 10.1.1.24
> > >
> > > How can I reference a named instance over IP?
> > >
> > > The web server is not part of the domain. Is it as simple as using the
> > same
> > > IP address with a different port (other than 1433)?
> > >
> > > Thanks
> > >
> > >
> >
> >
>
>

Report this post to a moderator