locked
how to connect mssql server 2000 over internet? RRS feed

  • Question

  • i try to connect mssql server  2000 over internet, i had port forward (default:1433), enable TCP/IP and add server alias in sql server client network utility, then i use http://canyouseeme.org/ to check port 1433 but it come back with service not found, any one can advise me how to fix it?
    Monday, November 7, 2011 3:41 AM

Answers

  • thanks for all replies, my version is 8.00.194,  this version not support server over internet?


    SQL Server version 8.00.194 is the RTM version of SQL Server 2000.  It is very important that you install the latest service pack (SP4) before exposing the server to the internet, especially without UDP port 1434 blocked.  Otherwise, you are vulnerable to the slammer worm.  Also. install the latest Windows updates to further protect you server.  This is especially important when the server is exposed to the public internet and the best practice is to have a hardware or software firewall configured to allow only the desired ports and/or IP addresses through.

    As preventially mentioned, IP addresses in the range 192.168.x.x are private IP addresses.  You'll need to specify the public IP address in order to connect from the internet.

     

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by Stephanie Lv Tuesday, November 15, 2011 9:45 AM
    Wednesday, November 9, 2011 3:24 AM
  • So did yu get it to work? And more importantly, did you install Service Pack4?

    The screen shots you posted do not seem correct. You make some configuration for named pipes, but named pipes will not work over the Internet.

    To connect to the server over the Internet, you need to use the 175.xxx.xxx.xxx address, but obviously there be something in your network that connects the incoming requests to this address. Also, you need to make sure that you understand the consquences of the port mapping. That is, while SQL Server listens to port 1433 on the local network, the router could listen on, say, port 4711, and forward these to port 1433 on your SQL Server machine. In this case, you need to connect to 175.xxx.xxx.xxx,4711.

    And again, you did install Service Pack4, didn't you? This is an absolute must if you are going to connect machine on the Internet.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by Stephanie Lv Tuesday, November 15, 2011 9:45 AM
    Saturday, November 12, 2011 6:16 PM

All replies

  • Windows Firewall is OFF? What error do you get? Have you run telnet to check it out?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, November 7, 2011 6:26 AM
  • Windows Firewall is OFF? What error do you get? Have you run telnet to check it out?
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, November 7, 2011 6:27 AM
  • thanks for your reply, yes it if off, i can connect to sql server through local lan, but fail over internet

    i try telnet 192.168.1.xx 1433, it fail too, any thing i still missing?

    Monday, November 7, 2011 10:46 AM
  • Talk to your network admin to check out the transmission to see any problems
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Monday, November 7, 2011 11:40 AM
  • Detailed troubleshooting steps How to Troubleshoot Connecting to the SQL Server Database Engine 
    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty
    Monday, November 7, 2011 4:18 PM
  • You cannot reach 192.168 from canyousee.org or any other place out on the big Internet.

    What does "SELECT @@version" report? If it's lower than 8.00.760 install SP4 before you expose that server over the Internet. And make sure that you have really strong passwords.

    You mentioned something about port-forwarding. That certainly sounds like a possible source for error.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Monday, November 7, 2011 10:21 PM
  • thanks for all replies, my version is 8.00.194,  this version not support server over internet?
    Tuesday, November 8, 2011 2:18 AM
  • Hi Kieve,

    Your version supports server over internet. You could follow below steps:

    1. Open SQL Server Network Utility, set the TCP/IP Enabled and set a PORT to use.
    2. If you have a Router (Port Forward the IP of your PC where your SQL Server is Installed)
    3. Now if your Internet IP is STATIC (Use DDNS service of your router) and if your Internet IP is DYNAMIC (Proceed to next step)
    4. Now after doing step 1-3 your SQL Server already has an internet connectivity so you must go to the Client PC from which you want to use (sample your server is Office PC and your client is your Home PC) OPEN "CLIENT NETWORK UTILITY"
    5. Open Alias TAB, Click ADD, Enter your SERVER ALIAS (Any name you want to use)
    6. In Network Libraries select TCP/IP
    7. In Connection Parameters - Server name = (your servers internet IP address)
    8. Click Dynamically determine port and ENTER THE PORT # (the port you set from router)
    9. Basically where done... OPEN SQL Server Enterprise Manager then Register your DATABASE!

    To share data over the Internet, the client and server must be connected to the Internet. In addition, you must use the TCP/IP or Multiprotocol Net-Libraries. If you use the Multiprotocol Net-Library, ensure that TCP/IP support is enabled. If the server is registered with Domain Name System (DNS), you can connect using its registered name. You could refer to http://msdn.microsoft.com/en-us/library/aa213767(v=sql.80).aspx.

    Here is a similar thread could help you: http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/27d63ce6-6717-4218-820a-7e2220dcbe47/.

     


    Thanks,
    Maggie


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Tuesday, November 8, 2011 8:55 AM
    • Edited by Kieve Wednesday, November 9, 2011 2:56 AM
    Wednesday, November 9, 2011 2:48 AM
  • thanks for all replies, my version is 8.00.194,  this version not support server over internet?


    SQL Server version 8.00.194 is the RTM version of SQL Server 2000.  It is very important that you install the latest service pack (SP4) before exposing the server to the internet, especially without UDP port 1434 blocked.  Otherwise, you are vulnerable to the slammer worm.  Also. install the latest Windows updates to further protect you server.  This is especially important when the server is exposed to the public internet and the best practice is to have a hardware or software firewall configured to allow only the desired ports and/or IP addresses through.

    As preventially mentioned, IP addresses in the range 192.168.x.x are private IP addresses.  You'll need to specify the public IP address in order to connect from the internet.

     

     


    Dan Guzman, SQL Server MVP, http://weblogs.sqlteam.com/dang/
    • Marked as answer by Stephanie Lv Tuesday, November 15, 2011 9:45 AM
    Wednesday, November 9, 2011 3:24 AM
  • So did yu get it to work? And more importantly, did you install Service Pack4?

    The screen shots you posted do not seem correct. You make some configuration for named pipes, but named pipes will not work over the Internet.

    To connect to the server over the Internet, you need to use the 175.xxx.xxx.xxx address, but obviously there be something in your network that connects the incoming requests to this address. Also, you need to make sure that you understand the consquences of the port mapping. That is, while SQL Server listens to port 1433 on the local network, the router could listen on, say, port 4711, and forward these to port 1433 on your SQL Server machine. In this case, you need to connect to 175.xxx.xxx.xxx,4711.

    And again, you did install Service Pack4, didn't you? This is an absolute must if you are going to connect machine on the Internet.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    • Marked as answer by Stephanie Lv Tuesday, November 15, 2011 9:45 AM
    Saturday, November 12, 2011 6:16 PM