up vote 1 down vote favorite
share [g+] share [fb]

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).

link|improve this question
feedback

2 Answers

up vote 1 down vote accepted

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

link|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
feedback
up vote 5 down vote

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 conencting from internet, enforce the SSL encryption requirement on the server side.
link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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