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 (889583)


The information in this article applies to:

  • Microsoft Commerce Server 2000

SYMPTOMS

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:
can not connect to SQL Server
Can not find MSCS_Admin database

RESOLUTION

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.
Modification Type:MajorLast Reviewed:1/25/2005
Keywords:kbhowto kbtshoot kbprb KB889583 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.