Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

My web hosting provider allows me to setup an SQL Server 2008 database from their web pages and then provides with an address of the form "tcp:domain.bla.net" that I can use to connect from anywhere. I can even use SS Management Studio!

My question is, how can I expose my own database in that way from my own server? (assuming I already have a fixed IP).

share|improve this question
add comment

2 Answers

up vote 1 down vote accepted

Open port 1443 on your firewall and it should be accessible by IP.

share|improve this answer
    
Assuming the instance is listening on the default port, but yes. –  MDMarra Nov 13 '09 at 19:59
1  
1433/1434: support.microsoft.com/kb/287932 –  Remus Rusanu Nov 13 '09 at 20:14
    
Remus is correct as you need 1433 and 34 –  Jim B Nov 13 '09 at 22:03
add comment

Just a word of caution here: port 1433 (the default SQL Server port) is subject to frequent port scans and brute sa password attacks on the internet. Your instance will be discovered in a matter of hours and will be subject to several automated attacks per day (I'm not kidding). I would highly recommend:

  1. Use a non default port
  2. Harden your SQL Server instance. Make sure you have a very strong sa password, expire and rotate your password, disable non-used logins, use a non sysadmin login when connecting from internet, enforce the SSL encryption requirement on the server side.
share|improve this answer
    
Plus note that you do not expose the DATABASE but the SERVER INSTANCE - with all databases that it hosts. Isolating the databases in question may be advisable. –  TomTom Feb 26 '13 at 9:45
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.