SQL Server Express 2008 R2

In this topic: Hide

 

Use the following instructions when installing a Microsoft SQL Express 2008 R2 with Tools for use with ATS Licensing Server and/or ATS Software Product installations. This procedure is only a generic example and your local MS SQL DBA should always be consulted.

Download Microsoft SQL 2008 Express R2

Download Microsoft SQL 2008 Express R2 from the Microsoft web site. The recommended version is SQL Express with Tools (SQLEXPRWT_x64_ENU.exe or SQLEXPRWT_x86_ENU.exe), which can be downloaded here: http://www.microsoft.com/en-us/download/details.aspx?id=30438

For a description of the other available versions of SQL Express, expand the Details section on the Microsoft download page in the link above.

Installing SQL 2008 Express R2

1.     Execute the SQL 2008 Express R2 installation.

2.     Click New installation or add features to an existing installation.

3.     Accept the license terms and click Next.

4.     Select the installation features.

5.     Select Named Instance. Enter a distinct name for this SQL Server instance (for example, 'CM4D' or 'License') to avoid possible conflict with other software.

6.     The Service Accounts Startup Type should be set to Automatic and Disabled. Then click Next.

7.     Under the Account Provisioning tab, select your Authentication Mode. Either option is valid for use with CM4D.

8.     Click Add.

a.     Select the local machine Administrators group to be added to the SQL Administrators.

i.        Enter the object name: 'administrators'

ii.      Click Check Names.

b.     Click OK.

9.     Click Next.

10.  If the host machine has multiple disk volumes, you can choose to change the data file directories to alternative drives in the Data Directories tab.

11.  Click Next.

12.  Click Close.