SQL Server Allow Remote Connections – Including Blocked by McAffee
16-Nov-1111 Leave a comment
A lot of websites have the basics of this. Applied steps and still did not work. Steps were
- Allow remote connections
- Start SQL Browser
- Ensure that Protocol for TCP/IP was enabled
- For new PC only adjustment to Firewall was addition of inbound port rule. Had to include Private network.
SOLVED However removed McAffee from the server (laptop) and remote connection worked immediately. Think this was the deciding ultimate solving step. Other Links http://blogs.msdn.com/b/walzenbach/archive/2010/04/14/how-to-enable-remote-connections-in-sql-server-2008.aspx http://support.microsoft.com/kb/914277 http://www.dummies.com/how-to/content/how-to-open-a-port-in-the-windows-7-firewall.html http://www.sevenforums.com/system-security/58817-remote-access-sql-server-express-2008-windows-7-a.html
For remote connection over the internet also need to use port forwarding on the router.