1b. Configure the Server Port

Applies to ReadyAPI 3.9, last modified on July 16, 2021

To configure the server port, you need to use the SQL Configuration Manager administration tool. Do not use the MS SQL Management Studio.

Enable TCP-IP

  • Start SQL Server Configuration Manager (in Configuration tools).

  • Select SQL Server Network Configuration > Protocols For <servername> and, in the right-side window, double-click TCP\IP.

    MS SQL Express: Selecting protocols for the server

    Click the image to enlarge it.

  • The Protocol Properties dialog appears.

    On the Protocol tab, set Enabled to Yes.

    MS SQL Express: Enabling the TCP-IP protocol

Set the port

  • In the Protocol Properties dialog, select the IP Addresses tab, scroll down to the IPAll section and enter the port number (1433 for this tutorial) in the TCP Port box.

    MS SQL Express: Entering the port number on the IP Addresses tab

    Click OK.

  • A reminder for you to restart the server will appear.

    MS SQL Express: The restart warning

    Click OK.

Restart the server

You can restart the server in the configuration manager.

  • Select SQL Server Services, right-click SQL Server (<servername>) and select Restart.

    MS SQL Express: Calling the context menu in SQL Configuration Manager

    Click the image to enlarge it.

    The server stops...

    MS SQL Express: Stopping the server

    ...and restarts.

    MS SQL Express: Starting the server

    Now, the server runs with new settings.

  • Close the Configuration Manager.

Note: For more information on the port configuration, see https://msdn.microsoft.com/en-us/library/ms177440.aspx.

Now, you can install the sample database.

Prev          Next

See Also

Microsoft SQL Databases as Data Sources

Highlight search results