How hard is it to install sql2008 on a server, and giving access to me from my home computer via Management Studio?
Can I lock this down to a particular IP address?
Asked
Active
Viewed 134 times
1
-
What version of Windows? – Nick Kavadias Sep 07 '09 at 22:42
3 Answers
1
It would be more secure to set up a VPN connection to the network where the SQL server is located and access it via the VPN connection.
joeqwerty
- 109,901
- 6
- 81
- 172
1
I agree with joeqwerty, but for the sake of answering your question itself it's not hard. You install SQL Server normally then configure your firewall to allow inbound connections to your server on the port your instance is listening (default is TCP 1433). You use the firewall to lock it down to a specific IP address.
squillman
- 37,883
- 12
- 92
- 146
0
Not hard at all?
I would change the default port from 1433 to something else, in case Slammer ever happens again.
The built-in windows firewall on windows server 2003 allows you to restrict an incoming service to a particular IP/network. See the example screen shot below. Don't forget to include your local network in the list. Nonetheless, I would still feel more comfortable putting an enterprise firewall in front of my server if i was putting it out on the internet.
Nick Kavadias
- 10,796
- 7
- 37
- 47