You may receive error messages that the connection cannot be established after you modify the SQL Server port number from the default setting in Commerce Server 2000

In Microsoft Commerce Server 2000, after you have modified the Microsoft SQL Server port number from the default setting of 1433, you may receive general error messages that indicate that the connection could not be established. These error messages may be similar to the following:

To resolve this issue, after you have changed the SQL Server port number, follow these steps:

1. Restart all SQL Services. For example, restart the MSSQLSERVER service by following these steps:
   1. Click Start, point to Administrative Tools, and then click Services.
   2. In the right pane of the Services dialog box, right-click MSSQLSERVER, and then click Restart.
2. Click Start, point to All Programs, point to Microsoft Commerce Server 2000, right-click Commerce Server Manager, and then click Properties.
3. In the Commerce Server Manager Properties dialog box, click the Administration Database tab, and then click Modify. The Data Link Properties dialog box appears.
4. In the Database Name box, type the following information:
   ServerName,Port
   Notes
   • Replace ServerName with the name of the server and replace Port with the SQL Server port number.
   • Use a comma (",") to separate the server name and the port number.
5. Click OK.