Installing Microsoft SQL Server

Prior to installing Microsoft SQL Server, complete the installation requirements (see Requirements for your Database Software).

Step 1. Installing Microsoft SQL Server

To install Microsoft SQL Server 2005, see:

https://msdn.microsoft.com/en-us/library/ms143516%28v=sql.90%29.aspx

To install Microsoft SQL Server 2008, see:

https://msdn.microsoft.com/en-us/library/bb500395%28v=sql.100%29.aspx

Step 2. Enabling the TCP/IP Protocol

TLC communicates with Microsoft SQL Server via the TCP/IP protocol. By default, this protocol is disabled in Microsoft SQL Server.

To enable the TCP/IP protocol on your Microsoft SQL Server database server, complete the following steps in the SQL Server Configuration Manager:

1. In the tree pane, select Protocols for MSSQLSERVER in SQL Server Network Configuration.
2. In the main pane, select and enable the TCP/IP protocol.
3. In the tree pane, right-click Protocols for MSSQLSERVER and select Properties.
4. In the Flags tab of the properties dialog, determine if Force Encryption (SSL) is enabled. If so, you will need to complete an additional step when you install Tripwire Log Center Manager.
5. Close the SQL Server Configuration Manager and restart Microsoft SQL Server.

Step 3. Creating a Microsoft SQL Server Login

To create the login with which TLC will access Microsoft SQL Server, complete the following steps in the Microsoft SQL Server Management Studio:

1. In the Object Explorer, expand the Security folder.
2. Under the Security folder, right-click Logins and select New Login.
3. If you are using Windows Authentication, complete the following steps in the General page of the Login – New dialog for the domain account that will be used as the service account to run the TLC Manager on your Primary Manager and Secondary Managers:
a. Click Search.
b. Enter the login name and click Check Names.

Note 

If you plan to enable Windows Authentication in the TLC Manager Configuration Wizard (see Step 2. Configuring TLC Manager), you must enter the Windows domain account.
c. If the search locates the login name, click OK.
d. From the Default database drop-down, select master.
e. From the Default language drop-down, select English.

If you are using SQL Server Authentication, complete the following steps:

a. Enter the Login name for your SQL Authentication account.
b. Select SQL authentication.
c. Enter and confirm the password for the login.
d. Clear the Enforce password expiration check box.
e. From the Default database drop-down, select master.
f. From the Default language drop-down, select English.

Caution 

If you fail to clear the Enforce password expiration check box, your SQL Server password could change. If the password changes, you will have to reset the password in the TLC Manager interface to re-establish communication between Microsoft SQL Server and TLC Manager.

Each SQL Server database has a transaction log that records each transaction (i.e., a single unit of work) and related database modifications. Since transaction logs may consume a large amount of disk space on the database server, Tripwire recommends that you monitor the size of the transaction log. For more information about SQL Server transaction logs, click here.

Tip 

Since you will need the login name and password to install TLC Manager (see Installing TLC Manager on your Primary Manager), make a note of it.
4. In the tree pane:
a. Click Server Roles.
b. Select dbcreator and click OK.
5. Click OK to close the Login – New dialog.