Installing SQL Server on a separate drive - Security Center 5.7 GA

Security Center Installation and Upgrade Guide 5.7 GA

series
Security Center 5.7 GA
revised_modified
2017-10-25

Depending on your deployment requirements, you might be required to install SQL Server on a drive that is separate from the system drive (typically the C: drive). You must perform this procedure before installing Security Center components.

Before you begin

If you are installing SQL Server Standard or Enterprise edition, you must purchase it from Microsoft, and download the installation package.

What you should know

You must install SQL Server on a separate drive in the following situations:
  • You plan to set up Directory failover and load balancing. In this case, install SQL Server on a server that is different from all your Directory servers.
  • Microsoft Volume Shadow Copy Service (VSS) is enabled on your server. In this case, install SQL Server on a drive that is separate from the system drive, and make sure that VSS only takes snapshots of the system drive.
    CAUTION:
    Do not disable VSS. Disabling VSS interferes with the operation of Windows System Restore.

Procedure

  1. Do one of the following:
    • If you are installing SQL Server Standard or Enterprise:
      1. In Windows, navigate to the SQL installation package folder.
      2. Double-click Setup.exe.
    • If you are installing SQL Server Express:
      1. In Windows, navigate to the Security Center installation package folder.
      2. Click SC Packages > SQLExpress.
      3. Double-click one of the following:
        • If you are on a 64-bit computer: SQLEXRWT_x64_ENU.exe.
        • If you are on a 32-bit computer: SQLEXRWT_x86_ENU.exe.
  2. On the SQL Server Installation Center page, click New installation or add features to an existing installation.
  3. On the Installation Type page, select New installation or add shared features, and then click Next.

  4. Read the software license terms, select I accept the license terms, and then click Next.
  5. On the Feature Selection page, select the features you want to install.
  6. In the Shared feature directory field, select where to install the SQL Server shared features.
  7. Click Next.
  8. On the Instance Configuration page, select a name for the SQL Server.
    NOTE: The database server name is not case-sensitive, but it must meet all of the following criteria:
    • It cannot match any of the SQL Server reserved keywords, such as DEFAULT, PRIMARY, and so on. For a complete list of all reserved keywords, see https://msdn.microsoft.com/en-us/library/ms189822.aspx.
    • It cannot be longer than 16 characters.
    • The first character of the instance name must be a letter or an underscore (_). Acceptable letters are defined by the Unicode Standard 2.0, including Latin characters a-z and A-Z, and letter characters from other languages.
    • Subsequent characters can be letters defined by the Unicode Standard 2.0, decimal numbers from Basic Latin or other national scripts, the dollar sign ($), or an underscore (_).
    • Embedded spaces or other special characters are not allowed: backslash (\), comma (,), colon (:), semi-colon (;), single quotation mark ('), ampersand (&), number sign (#), and at sign (@).
  9. In the Instance root directory field, select where to install the SQL Server and all directory database files, and click Next.

    You can type a path, or browse for a folder.

  10. On the Server Configuration page, select the account name for each SQL Server service, and click Next.

  11. On the Database Engine Configuration page, select the authentication mode for accessing the Database engine, and click Next.
    Windows authentication mode
    Windows username and password.
    Mixed mode
    Windows administrators can access the database engine using either their Windows credentials, or the password you specify here.

  12. On the Error Reporting page, specify if you want to send errors to Microsoft, and click Next.
  13. Wait for the installation to complete. This can take several minutes.
  14. Click Close.

Results

The SQL Server can now be used as your Security Center database server.

After you finish

Install Security Center on the main server, and use the new SQL Server as your database server.