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:
Procedure
-
Do one of the following:
- If you are installing SQL Server Standard or Enterprise:
- In Windows, navigate to the SQL installation package folder.
- Double-click Setup.exe.
- If you are installing SQL Server Express:
- In Windows, navigate to the Security
Center installation
package folder.
- Click .
- 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.
-
On the SQL Server Installation Center page, click
New installation or add features to an existing
installation.
-
On the Installation Type page, select New
installation or add shared features, and then click
Next.
-
Read the software license terms, select I accept the license
terms, and then click Next.
-
On the Feature Selection page, select the features you
want to install.
-
In the Shared feature directory field, select where to
install the SQL Server shared features.
-
Click Next.
-
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.
- 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 (_).
- It cannot contain spaces or the following characters: \ , : ; '
& # @
-
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.
-
On the Server Configuration page, select the account name
for each SQL Server service, and click Next.
-
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.
-
On the Error Reporting page, specify if you want to send
errors to Microsoft, and click Next.
-
Wait for the installation to complete. This can take several minutes.
-
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.