Enabling MS SQL Remote Access

By default, MS SQL does not enable remote access after a clean install. To enable this:

  1. Launch Sql Server Configuration Manager

    Sql Server Configuration Manager

    Sql Server Configuration Manager

  2. Double click TCP/IP, in the Protocol tab under the General section, set the Enabled to Yes.
  3. In the IP Addresses tab, scroll to the button. In the IPAll section assign the port to TCP Port. To use MS SQL default port, assign it to 1433.

    TCP/IP Properties

  4. Finally, remember to set the firewall to allow the incoming TCP connection.

    Windows Firewall with Advanced Security

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s