Enabling remote access to a SQL Server instance

  • Article ID: 118473
  • Rating:
  • 13 customers rated this article 3.3 out of 6
  • Updated: 11 Mar 2014

The following article describes how to configure a Microsoft SQL Server instance to be remotely accessible over TCP/IP.  

This configuration change may be required when a Sophos product such as Sophos Enterprise Console or PureMessage for Microsoft Exchange is required to access a remote SQL Server instance as part of a distributed installation.

Known to apply to the following Sophos product(s) and version(s)

PureMessage for Microsoft Exchange
Enterprise Console

What To Do

  1. On the SQL Server, open 'SQL Server Configuration Manager'.  

    Note
    : This can typically be found linked from the 'Start' menu.  For example: Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools | SQL Server Configuration Manager.

  2. Expand 'SQL Server Network Configuration' and highlight the 'Protocols for [InstanceName]' option.

  3. In the right-hand window, if 'TCP/IP' currently has the 'status' of 'Disabled', right click on 'TCP/IP' and select 'Enable'.

    Note:
    You will be requested to restart the SQL Server service to complete the configuration change. 

  4. To restart the service, you can use the same Microsoft Management Console (MMC) window.  To do so, highlight the 'SQL Server Services' option at the top of the tree. In the right-hand window, you can then right click on the 'SQL Server [Instance]' entry and choose 'Restart'.
The SQL instance has now been configured to accept TCP/IP connections from remote computers.

 
If you need more information or guidance, then please contact technical support.

Rate this article

Very poor Excellent

Comments