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 https://go.microsoft.com/fwlink/?LinkID=17516.