Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 2008 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 2008 > 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 2008 installation.
  4. Determine if whether the TCP/IP protocol is enabled or disabled.

    Image Added
     
  5. If disabled, right-click the TCP/IP protocol and select Enable from the pop-up menu. Enable TCP/IP Image Removed 
  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.