I. Create database and login in SQLServer using
SQLServer Enterprise Manager
1. Create Database for WebSphere Repository called WAS40
2. Create a Login called EJSADMIN with password EJSADMIN (or something
else) with the followings:
Default database is WAS40
Grant 'db_owner' role in WAS40
II. Installed and Configured SequeLink Server for MS SQLServer
This note assumes SequeLink Server for MS SQLServer is installed and
configured. The SLSQLServer51 service is running on port 19996.
(For more information, please see the Hint & Tip title:
How to Install MERANT SequeLink Server for Use with SequeLink JDBC
Driver?)
III. Edit the admin.config
1. Add the j2ee.jar, sljc.jar and sljcx.jar to the AdminServer's
classpath, for example
com.ibm.ejs.sm.adminserver.classpath=C:/WebSphere/AppServer/lib/j2ee.jar;C:/WebSphere/AppServer/lib/sljc.jar;C:/WebSphere/AppServer/lib/sljcx.jar;C:/WebSphere/AppServer/properties;C:/WebSphere/AppServer/lib/bootstrap.jar
2. Add the values for Repository database attributes, for example,
# Repository database settings
com.ibm.ejs.sm.adminServer.dbdataSourceClassName=com.merant.sequelink.jdbcx.datasource.SequeLinkDataSource
com.ibm.ejs.sm.adminServer.dbserverName=earth-tgp
com.ibm.ejs.sm.adminServer.dbportNumber=19996
com.ibm.ejs.sm.adminServer.dbdatabaseName=was40
com.ibm.ejs.sm.adminServer.dbuser=ejsadmin
com.ibm.ejs.sm.adminServer.dbpassword=ejsadmin
com.ibm.ejs.sm.adminServer.dbdisable2Phase=true
3. If you didn't use EJSADMIN as the login name in SQLServer (step 1
section I), then you must change the dbSchema to specify the dbSchema to
reflect the login name that was created:
com.ibm.ejs.sm.adminServer.dbSchema=EJSADMIN.
|