Microsoft KB Archive/889583

= 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 =

Article ID: 889583

Article Last Modified on 1/25/2005

-

APPLIES TO


 * Microsoft Commerce Server 2000 Standard Edition

-





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:  Restart all SQL Services. For example, restart the MSSQLSERVER service by following these steps:  Click Start, point to Administrative Tools, and then click Services. In the right pane of the Services dialog box, right-click MSSQLSERVER, and then click Restart.  Click Start, point to All Programs, point to Microsoft Commerce Server 2000, right-click Commerce Server Manager, and then click Properties. In the Commerce Server Manager Properties dialog box, click the Administration Database tab, and then click Modify. The Data Link Properties dialog box appears. In the Database Name box, type the following information:

,

Notes <ul> Replace  with the name of the server and replace   with the SQL Server port number.</li> Use a comma (&quot;,&quot;) to separate the server name and the port number.</li></ul> </li> Click OK.</li></ol>

Keywords: kbhowto kbtshoot kbprb KB889583

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.