Enabling Remote Connectivity for SQL Server

The purpose of this topic is to describe how to enable remote connectivity for SQL Server after it has been installed. 

Depending on the version of SQL Server you installed, the TCP/IP protocol may be disabled for the SQL Server database engine. You need to enable this protocol in order to connect to the Aptify server from other computers over the network. Follow these steps:

  1. When the installation is complete, launch the SQL Server Configuration Manager (from Start > All Programs > SQL Server > Configuration Tools).
  2. Expand the SQL Server Network Configuration node in the pane on the left.
  3. Select the Protocols option for your SQL Server installation.
  4. Determine whether the TCP/IP protocol is enabled or disabled.


     
  5. If disabled, right-click the TCP/IP protocol and select Enable from the pop-up menu. 
  6. Click the SQL Server Services heading in the pane on the left and restart the SQL Server service for the change to take effect.
Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.