Enable Remote Connections to SQL Server 2008

1. Enable remote connections to Sql Server. The instructiions are for SQL Server 2005, but the steps are the same for 2008. http://www.linglom.com/it-support/enable-remote-connection-on-sql-server-2008-express/

2. Set up Inbound and Outbound rules for TCP port 1433. http://www.dummies.com/how-to/content/how-to-open-a-port-in-the-windows-7-firewall.html

3. Set up Inbound and Outbound rules for UDP port 1434. http://www.dummies.com/how-to/content/how-to-open-a-port-in-the-windows-7-firewall.html

4. Set up inbound and outbound exceptions for sqlservr.exe. I am running a 64 bit machine so this file was located here: C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Binn\sqlservr.exe. http://www.sevenforums.com/tutorials/542-windows-firewall-add-remove-exception.html

5. Set up inbound and outbound exceptions for sqlbrowser.exe. Again, I am running a 64 bit machine so the file was located here: C:\Program Files (x86)\Microsoft SQL Server\90\Shared\sqlbrowser.exe. http://www.sevenforums.com/tutorials/542-windows-firewall-add-remove-exception.html

6. Restart your machine.

References

• Original source of information: http://www.sevenforums.com/system-security/58817-remote-access-sql-server-express-2008-windows-7-a.html