WebSphere

Manually creating a SQL Server event database

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
  1. 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.
  2. Using an ASCII text editor, make any required modifications to the cr_event_mssql.bat script.
  3. 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
  4. 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.


task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_run_db_script_sqlserver.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).