Ok this will be a short post, but I am posting this because it is something I overlooked when doing a clean install of Windows 7 on my desktop computer. Besides being a basic desktop computer, this desktop runs my SQL Server. Well since I put Windows 7 on, I figured I would do an install of SQL Server 2008 and get rid of SQL Server 2005. Anyway, after putting all my databases back I was having problems connecting to it via my laptop...which is also running Windows 7 with an instance of SQL 2008. Now to the problem. I could not connect to the SQL 2008 database on my desktop remotely via SQL Server Management Studio from my laptop. I think to myself...no worries I'll go enable it.
I did the following on my desktop.
- Opened SQL Server Management Studio
- Right Clicked the Server and went to properties
- Selected Connections on the left hand side
- Enabled "Allow remote connections to this server"
Simple enough right?
Not so much. I forgot about Windows 7 firewall being enabled!!! My choice was to completely disable it (which wouldn't be a horrible thing since I'm behind a router/firewall), however I wanted to keep it enabled.
Here is what to do. Open up TCP Port 1433 on your Windows firewall and all is well.
- Go to the Advanced Settings of your Windows Firewall
- Click on Inbound Rules
- Click New Rule
- Rule Type is Port
- Apply to TCP only
- enter 1433 for the Specific Local Ports
- Finish the rest of the wizard and you should be good to go!
Here is a good resource for SQL Server and Firewall
http://msdn.microsoft.com/en-us/library/cc646023%28v=SQL.100%29.aspx
cf1da303-5d7f-46c9-843d-06fed3b99d69|0|.0
Microsoft SQL