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

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?

share|improve this question
    
What version of Windows? –  Nick Kavadias Sep 7 '09 at 22:42

3 Answers 3

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.

share|improve this answer

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.

share|improve this answer

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.

alt text

share|improve this answer

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.