Connecting to SQL Server over the Internet

By making your SQL server accessible over the Internet, you can allow worldwide client access to your data. Although this permits a large degree of information sharing, it comes with the added burden of securing access to that data.

To connect your client application to a Microsoft SQL server over the Internet, both the client and server must have access to the Internet. In addition, the server must be running either TCP/IP Sockets or the Multiprotocol Net-Library. If you are using Multiprotocol, make sure that TCP/IP support is enabled. After these two requirements are satisfied, the client can then connect to a specific IP address; if the computer is registered with a domain name sever (DNS), the client ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.