Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Overview of the SQL Server 2000 Implementation for MIIS 2003

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

It is important to understand the relationship between SQL Server 2000 editions and the editions of MIIS 2003. It is also important to understand some general recommendations for running SQL Server 2000 and the MIIS database. For example, backup types and recovery models, which are a part of SQL Server database maintenance, are critical to the safety concerns of your MIIS 2003 data.

SQL Server 2000 and Windows Server 2003 Supported Editions

Each edition of MIIS 2003 is supported by specific editions of Microsoft® Windows Server™ 2003 and SQL Server 2000. Table 1 lists the Windows Server 2003 and SQL Server 2000 editions that support each edition of MIIS 2003.

Table 1   Windows Server 2003 and SQL Server 2000 Editions

 

This MIIS 2003 Edition Is Supported by These Windows Server 2003 Editions And by These SQL Server 2000 Editions

Standard Edition

Standard Edition

Enterprise Edition

Enterprise Edition (with SP3*)

Standard Edition (with SP3)

Enterprise Edition

Enterprise Edition

Enterprise Edition (with SP3)

* Service Pack 3.

MIIS 2003 Requirements for SQL Server 2000

The following are MIIS 2003 requirements for SQL Server 2000:

  • SQL Server 2000 and MIIS 2003 can be installed on the same server or different servers, but they must be located in the same domain.

  • If you configure SQL Server 2000 to use a communications port other than the default SQL Server port 1433, you must use the SQL Server Client Network Utility on the computer on which you run MIIS 2003 to set the communications port to be used by SQL Server clients on that computer.

For more information about setting the communications port, see “Configuring SQL Server 2000 to Support MIIS 2003” later in this topic.

Recommendations for Running SQL Server 2000 to Support MIIS 2003

The following recommendations for running SQL Server 2000 will help you to improve the performance and efficiency of your MIIS 2003 installation:

  • Do not attempt to manually modify data that is stored in the MIIS database. Modify the database only by using Identity Manager, which can determine if and what changes are necessary.

  • Maintain your transaction log files for the MIIS database on a separate drive from the drive that contains the MIIS database.

  • To ensure availability and provide redundancy in large-scale environments, use SQL Server clustering with MIIS 2003, Enterprise Edition.

  • In addition to using the performance improvement methods described elsewhere in this document, use performance tuning to optimize SQL Server 2000 performance.

For information about SQL Server 2000 performance tuning, see “Chapter 20 - RDBMS Performance Tuning Guide for Data Warehousing” on the Microsoft Web site at http://go.microsoft.com/fwlink/?LinkID=17516.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.