Configuring SQL Server 2000 to Support MIIS 2003

  • Article

Applies To: Windows Server 2003, Windows Server 2003 R2, Windows Server 2003 with SP1, Windows Server 2003 with SP2

To meet the requirements and recommendations for MIIS 2003, be sure that your SQL Server 2000 implementation is configured correctly. First, verify that the correct version of SQL Server 2000 is running in your environment. Then, check whether SQL Server 2000 is configured to use the correct communications port, and reconfigure it, if necessary.

To verify that the correct version of SQL Server 2000 is running

  1. In Microsoft SQL Server, click Query Analyzer.

  2. In the Connect to SQL Server dialog box, type your server name, click a connection option, and then click OK.

  3. In the Query box, type or select the appropriate version.

  4. On the Query menu, click Execute.

The query returns the version of SQL Server 2000 that is running. Ensure that you are running version number 8.00.760, which indicates SQL Server 2000 SP3 or later.

By default, SQL Server 2000 uses communications port 1433. If SQL Server 2000 is configured to use a port other than 1433, you must use the SQL Server Client Network Utility on the computer running MIIS 2003 in order to change the communications port. You must do this even if MIIS 2003 is running on the same computer that SQL Server 2000 is running on.

To determine which communications port that SQL Server 2000 is using

  1. In Microsoft SQL Server, click Server Network Utility.

  2. On the General tab, under Enabled Properties, click TCP/IP, and then click Properties. The configured port is listed in Default port.

To change the communications port that SQL Server 2000 is using

  1. On the computer that is running MIIS 2003, open Microsoft SQL Server, and then click Client Network Utility. (If this item does not appear, you must first install the SQL Server client tools from the SQL Server 2000 installation media.)

  2. On the General tab, under Enabled protocols by order, click TCP/IP, and then click Properties.

  3. In the Default port box, type the communications port in use by SQL Server 2000, and then click OK.

  4. Click OK to close the Client Network Utility.

Important

The server and client port numbers must match.