Enable remote connections in SQL Server 2008

Basically few things:

  • SSMS -> server properties -> Connections
    Allow remote connections to this server checked
  • SSMS -> server properties -> Security
    SQL Server and Windows Authentication mode checked
  • SQL Server Configuration Manager -> SQL Server Network Configuration TCP/IP enabled
  • TCP/IP -> Properties -> IP Addresses
    Every IP needs to have 1433 (default one) port set
  • sometimes Firewall needs extra inbound rule for 1433 port
    (Click on Advanced Settings on the left hand side and you should see the Windows Firewall with Advanced Security. Select the Inboud Rules on the left hand side and click on New Ruleā€¦ on the right hand side.)

Woulktrhough here

Leave a Reply

Your email address will not be published. Required fields are marked *