You can install an MS SQL 7.0 (with Service Pack 2) database and the ContentReporter server on the same machine or on different machines. If you install them on different machines, you must install an MS SQL client on the ContentReporter server machine.
The following screen shows the DB Admin tab with MS SQL settings.
The following table describes the MS SQL database settings in ContentReporter.
Setting
|
Description
|
|---|
User name
|
The username of the MS SQL login that ContentReporter uses to access the database listed in the DB Name field.
The default is the "sa" login.
ContentReporter can also use a login that meets the following three requirements:
- granted only the Server Administrator role
- has only "Public" and "db_ddladmin" privileges for the ContentReporter database (listed in the DB Name field)
- defaults to the ContentReporter database (listed in the DB Name field)
|
Password
|
The password of the MS SQL login that ContentReporter uses to access the database listed in the DB Name field. The default is no password.
|
Hostname
|
The MS SQL server machine name.
Example
If the machine name is "bills-nt.domainname.com," the host name is either "bills-nt" or "bills-nt.domainname.com."
|
Port
|
The port through which the ContentReporter server connects to an MS SQL database. The default port is 1433.
|
Database Home
|
The root directory of the MS SQL server, or of the MS SQL client installation on the ContentReporter server machine. The typical directory is C:\MSSQL7\ (or the directory in which MS SQL is installed).
|
DB Name
|
The name of the database you created in MS SQL for ContentReporter. The default database name is "crsettings."
|
To configure an MS SQL database and a login for ContentReporter, complete the following steps.
Step
|
Action
|
|---|
|
1 |
To create a database for ContentReporter in the MS SQL Manager console, expand the database server in the left-hand console tree (under Console Root | Microsoft SQL Servers | SQL Server Group), right-click Databases, and then click New Database.
|
|
2 |
In the Database Properties window, enter a name (the default is "crsettings"), set any other file properties, and click OK.
|
|
3 |
Right-click the new database in the console tree (under the database server), and click Properties.
|
|
4 |
In the Properties window, click the Options tab, ensure that the "Select into/bulk copy" check box is selected, and click OK.
|
|
5 |
If...
|
Then...
|
You want ContentReporter to use the "sa" System Administrator SQL login
|
- Expand Security in the
console tree, click Logins,
right-click the "sa" login,
and click Properties.
- Identify or enter a password
for the "sa" login, click OK,
and go to Step 7.
|
You want to create a new SQL login for ContentReporter
|
Go to Step 6.
|
|
6 |
To create a new SQL Server Administrator login for ContentReporter, complete the following steps:
- Expand Security in the console tree, right-click Logins, and click
New Login.
- Enter a name for the login, click the SQL Server Authentication
button, enter a password for the login, select the new
ContentReporter database from the lower default Database drop-
down list, and then click the Server Roles tab.
- Select only the Server Administrators role check box, and click
the Database Access tab.
- Select the Permit box next to the database in the upper panel,
select only the "public" and the "db_ddladmin" check boxes in the
lower panel, and click OK.
- Enter the password, and click OK.
|
|
7 |
If...
|
Then...
|
The ContentReporter server and the MS SQL database are on different machines
|
Install an MS SQL client on the ContentReporter server machine.
|
The ContentReporter server and the MS SQL database are on the same machine
|
Go to step 8.
|
|
8 |
Go to Configuring ContentReporter to use MS SQL.
|
To configure ContentReporter to use an MS SQL database, complete the following steps.
Step
|
Action
|
|---|
|
1 |
Log into ContentReporter, and click the Administration tab.
|
|
2 |
Click the Admin button.
|
|
3 |
From the Cache Groups tab, click the DB Admin tab.
Note
At any point, you can click Reset to reset the database settings on this tab to their current (actual) state. |
|
4 |
Select SQL Server from the Database drop-down list.
|
|
5 |
Enter the MS SQL login user name (or leave "sa") in the Username field, and then enter the login password in the Password field.
|
|
6 |
Enter the MS SQL server machine name in the Hostname field.
|
|
7 |
Ensure that port 1433 (or the appropriate port) appears in the Port field.
|
|
8 |
Enter (or click Browse, browse to, and select) the root directory of the MS SQL server or client installation in the Database Home field.
|
|
9 |
Enter the name of the SQL database (the default is "crsettings") you created or identified for ContentReporter.
|
|
10 |
Test the ContentReporter server's connection to the SQL database by clicking Test DB Connection.
|
|
11 |
If...
|
Then...
|
A successful connection exists between ContentReporter and the SQL database
|
- Click OK.
- Click OK again.
|
The database connection test failed
|
- Click OK.
- Verify the information you
entered and check network
connectivity between the
ContentReporter server and
the SQL server.
- Repeat Step 9.
|
|
12 |
From the Administration page, log out of ContentReporter.
|
|
13 |
Stop and restart the ContentReporter service.
(In Windows NT: Click Start > Settings > Control Panel > Services. Then stop and start the ContentReporter service. In Windows 2000: Right-click My Computer > Manage > expand Services and Applications > double-click Services. Then stop and start the ContentReporter service.)
Note
Any time you modify database settings, you must stop and restart the ContentReporter service for the new settings to take affect. You might need to wait a moment for ContentReporter to start running. Result:
You successfully configured ContentReporter to use an SQL database.
|
