Use the cr_event_mssql command to manually
generate a database configuration script for a SQL Server event database.
About this task
To manually run the generated database configuration script
for a SQL Server event database:
Procedure
- On the server system, go to the directory containing the
generated script. The default location is theprofile_root/databases/event/node/server/dbscripts/sqlserver
directory; if you specified a value for the outputScriptDir parameter
of the database configuration administrative command, the scripts
are stored in that location instead.
- Using an ASCII text editor, make any required modifications
to the cr_event_mssql.bat script.
- Run the database creation script using the following syntax:
cr_event_mssql user_id password [server=server] sauser=sa_user
sapassword=sa_password
The parameters
are as follows:- user_id
- The SQL Server login user ID that will own the created tables.
This user ID must be created in SQL Server so that a JDBC connection
can be made to the database. (The JDBC drivers do not support trusted
connections.)
- password
- The password for the new login user ID that is created.
- server=server
- The name of the server that contains the SQL Server database.
This parameter is optional; the default value is the local host.
- sauser=sa_user
- The sa user ID. This user ID must have sufficient privileges to
create databases and user logins.
- sapassword=sa_password
- The sa password, if using mixed authentication mode. If the sa
user ID does not have a password set, specify sapassword= with
no value. Omit this parameter if you are using a trusted connection.
For example, the following command would create
the SQL Server event database using the login user ID
userid:
cr_event_mssql userid apassword server=myserver sauser=sa sapassword=sapassword
- Restart the server. For a federated node, you
must also stop and restart the node agent using the stopNode and startNode commands.
What to do next
After you finish configuring the database, you can use
the administrative console to test the database configuration. To
do this, navigate to the appropriate JDBC data source and select the Test
Connection option.