Configure MSSQL Communication Settings

Author: [email protected] 18 views

The configuration of Communication Settings for MSSQL might vary a little for different versions of MSSQL. The following describes how the configuration is completed in a MSSQL Server 2005 Express environment on a Windows 2003 Server. Open the “SQL Server Configuration Manager” through the “Start” -> “Microsoft SQL Server 2005” -> “Configuration Tools” – > “SQL Server Configuration Manager” menu.

<Insert Image>

Navigate the “Protocols for …” and select the “TCP/IP” protocol and select “Properties” from the context menu.

<Insert Image>

In the “Protocol” tab select “Yes” for the “Enabled” property.

<Insert Image>

In the “IP Addresses” tab specify the desired port (e.g. 1433) for the “TCP Port” under the “IP All” section or different if desired. After selecting “OK” the following prompt will be shown.

<Insert Image>