How to Configure WebSphere to Use MS SQLServer as Repository Using SequeLink JDBC Driver?
 Technote (FAQ)
 
Problem
Configure WebSphere to Use MS SQLServer as Repository Using SequeLink JDBC Driver
 
Solution
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.

 
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Administrative Console (all non-scripting)
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1050857
IBM Group: Software Group
Modified date: Nov 19, 2003