0

I would like to connect from client PC to SQL Server over the internet. I have installed SQL Server 2005. Can you guide me. I am new to this.

John Gardeniers
  • 27,458
  • 12
  • 55
  • 109
Abdulla
  • 1
  • 3
    This is a very bad idea. Is there any reason why you need to expose your SQL server to the internet rather than using a VPN? If you want to do this safely, it can be quite complicated, and as a result we can only give you overview steps. – Mark Henderson Oct 10 '11 at 02:53

1 Answers1

2

If you absolutally must access your SQL server over the internet, here is the birds-eye-view of what you need to do:

  1. Permit inbound SQL connections from remote computers inside the SQL server. This is disabled by default in SQL Server 2005.

  2. Permit inbound SQL connections on your Windows firewall (Port 1433)

  3. Expose your SQL Server to the internet. Most commonly this will involve setting up a Port Forwarding for Port 1433 through your edge device to your SQL Server.

  4. Permit inbound SQL Connections through your edge firewall (Port 1433).

  5. To do this properly, you should absolutally lock down your edge firewall to only permit SQL Traffic from a very, very small number of IP addresses (the public IP address of the client you are going to use to connect to the server). I have a honeypot SQL Server set up and it gets about 1,000 attempts a day from different chinese botnets trying to break into it. Not doing this step is asking for huge trouble.

For the specifics for #1, you will find how to do that here. For #2, how to do so depends on your operating system. For #3 - #5 we will be unable to help you here because it requires very specific knowledge of your network setup.

Community
  • 1
Mark Henderson
  • 68,823
  • 31
  • 180
  • 259