SQL Server with Merant Database Configuration
Run the ImportSamples script to create a SAMPLE database, create a SAMPLE data
source, and install the Samples Enterprise Application on your WebSphere Application
Server.
- On Windows:
- Verify that the WebSphere Application Server has started.
- Open a command window.
- Change to the <WAS_ROOT>\bin directory.
- Invoke the following script:
ImportSampleSQLServer.bat SQL_Server_Server_Name
SQL_Server_DBA_userid SQL_Server_DBA_password
where:
- SQL_Server_Server_Name is the SQL Server name.
- SQL_Server_DBA_userid is the SQL Server DBA user ID.
- SQL_Server_DBA_password is the SQL Server DBA password.
Here is an example of the command syntax for Windows:
ImportSampleSQLServer.bat myServer admin passwd
The script
requires that you provide the user ID and password of an account that
has SQL DBA authority.
- Start or restart the Default Server.
- Select Enterprise Application and click Refresh,
to show the newly installed Enterprise Application.
Run the servlet to create and configure the tables in the SAMPLE database.