Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

SO i have a server running windows server 2008 r2 and i just installed Microsoft sql server 2008. I used the manager thing to create the database and the tables, etc and now i want to connect to it via my visual studio which is on a different machine. so how do i do that? do i need to "turn on" the sql server, do i need to do port forwarding? do i have to modify the iis or change those settings? is there a good article someone can me point me to? just to further help you help me, i understand how to connect to a datasource in visual studio my problem is more with the sql server and understanding how to properly set it up once installed.

Sorry for the noob question, i got it all installed and i know how to use it once its all going i just don't know the in-between.

thanks in advance dave

share|improve this question
up vote 0 down vote accepted

First of all, you should check if TCP is enabled in your SQL Server instance, and enable it if it's not:

Then, you need to configure Windows Firewall on the server to allow incoming connections to your database:

share|improve this answer
perfect, the windows firewall article was difficult to follow, im not sure it was for my setup but it helped me figure it out. thanks again soo much – letseatlunch Apr 12 '10 at 0:00

Your Answer


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.