Configuring MSSQL Settings For Connector

Author: [email protected] 35 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.

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

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

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.

Now restart the MSSQL service to complete the configuration.