How to Configure MIIS to Install Database and Log files on Separate Drives (823798)


The information in this article applies to:

  • Microsoft Identity Integration Server 2003 Enterprise Edition
  • Microsoft Identity Integration Feature Pack for Microsoft Windows Server Active Directory

SUMMARY

When you configure Microsoft Identity Integration Server (MIIS) or Microsoft Identity Integration Feature Pack (IIFP), you have two installation options: Custom or Typical. Depending on the option that you select, and also on your Microsoft SQL Server configuration, the MIIS database and the MIIS log files may be installed on the same physical drive. For performance reasons, Microsoft typically does not recommend this configuration. This article describes how to install the MIIS database files and the MIIS log files on separate physical drives.

MORE INFORMATION

Configure Default Locations for New SQL Database and Log Files

To configure default locations for new SQL Server database files and log files, follow these steps.

Note This procedure will affect all new database instances that are installed on this computer running SQL Server.
  1. Start Microsoft SQL Server, and then click Enterprise Manager.
  2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand server_name (where server_name is the computer that SQL Server 2000 is running on). Right-click the server name, and then select Properties.
  3. In the SQL Server Properties dialog box, click the Database Settings tab. In the New Database Default Location section of the dialog box, you will see Default Data Directory and Default Log Directory boxes.
  4. Click the ellipsis button (...) next to the Default Data Directory box, and then select the location for the database files.
  5. Click the ellipsis button (...) next to the Default Log Directory box, and then select the location for the log files.
  6. Click OK to save your changes.
  7. Stop and then restart SQL Server.

Use the Custom Setup Option to Select the SQL Server Database Location for Database and Log File Storage

To use the Custom Setup option, follow these steps:
  1. Start the Setup Wizard, and then when you see the welcome screen, click Next.
  2. Accept the license agreement, and then click Next.
  3. On the Type of Installation page, click Custom Setup.
  4. On the Installation Preference page, click Next.
  5. On the Store Location page, select the computer running SQL Server and the instance where you set the file location properties in steps 3 through 5 of the "Configure Default Locations for New SQL Database and Log Files" section of this article.
  6. On the database File Location page, click SQL Server Folder under Store database files in, and then click Next.
  7. Type the service account information, and then click Next.
  8. Click Next to create the security groups.

    Note If you are installing on a member server, and you want to create a Domain group, you must pre-create the groups. Otherwise, they will be created as local groups.
  9. Click Start to start the installation.
  10. If you receive warning message 25051, you can click OK, but this message warns you that your service account is not secure in its current configuration. Make sure that the user rights on the MIIS or the IIFP server are set so that the MIIS service account can log on only as a service.
  11. Setup will prompt you to make a backup of the encryption keys. Enter the encryption key set name and location in the Save Encryption Keys dialog box. Because encryption keys are important for database recovery, make sure to note the backup file name and location.
  12. Click Finish to complete the installation.
Modification Type:MajorLast Reviewed:8/7/2003
Keywords:kbhowto KB823798 kbAudITPRO
©2003 Microsoft Corporation. All rights reserved.