Very Computer

by **John Hage** » Tue, 30 Mar 1999 04:00:00

Hi. I know there should be adequate information on this, but I'm having a
whale of a time finding it. I need a step-by-step guide to gain access to a
SQL Server database through the Internet. I have searched Microsoft's MSDN
Online and came up with zilch. I've searched all over their web site and
can't find any information. In short, we have a client for whom we're
hosting their data. They need to be able to do ad-hoc queries against the
data. I need very specific instructions on how to set this up on both the
client and server sides. Believe me, any help will be appreciated!

Thanks,
John

by **Gert Draper** » Tue, 30 Mar 1999 04:00:00

SQL Server can use TCP/IP sockets so all you have to do is configure it
correctly, so that you can resolve your hostname and connect.

If you connect through a proxy you have more work. SQL Server 7.0 has beter
configuration options when running through a proxy,but that is all to it to
connect over the internet, it is just an other TCP/IP socket connection and
by default you connect to port 1433.

-GertD

by **John Hage** » Wed, 31 Mar 1999 04:00:00

Ok, now I know I have to configure it correctly. Let's expand the
"configure it correctly" part by finding some step-by-step instructions on
how to do so. :)

Thanks to anyone who can offer some help!

John

>SQL Server can use TCP/IP sockets so all you have to do is configure it
>correctly, so that you can resolve your hostname and connect.

>If you connect through a proxy you have more work. SQL Server 7.0 has beter
>configuration options when running through a proxy,but that is all to it to
>connect over the internet, it is just an other TCP/IP socket connection and
>by default you connect to port 1433.

>-GertD

by **Barry Bogar** » Wed, 21 Apr 1999 04:00:00

> Ok, now I know I have to configure it correctly. Let's expand the
> "configure it correctly" part by finding some step-by-step instructions on
> how to do so. :)

> Thanks to anyone who can offer some help!

> John

> >SQL Server can use TCP/IP sockets so all you have to do is configure it
> >correctly, so that you can resolve your hostname and connect.

> >If you connect through a proxy you have more work. SQL Server 7.0 has beter
> >configuration options when running through a proxy,but that is all to it to
> >connect over the internet, it is just an other TCP/IP socket connection and
> >by default you connect to port 1433.

> >-GertD

YEAH! Details would be wonderful!

Very Computer

Connecting To SQL Server via Internet

Connecting To SQL Server via Internet

Connecting To SQL Server via Internet

Connecting To SQL Server via Internet

Connecting To SQL Server via Internet