Appboard/old/configuration database/example mssql

This section describes the following tasks that must be performed in order to use SQL Server with enPortal:

Downloading the Microsoft SQL JDBC Driver

After you have installed enPortal, you must download a JDBC driver that will enable enPortal to establish a connection to your Microsoft SQL Server database.

To install the JDBC driver:

1. Access the jTDS driver files at the following location: http://jtds.sourceforge.net/
2. Download the file jTDS-1.2-dist.zip to your local file system.
3. Locate the file jtds-1.2.jar within the downloaded zip file.
4. Extract the file jtds-1.2.jar and place it in the folder PORTAL_HOME/classes-custom/

Installing Microsoft SQL Server

These installation instructions apply to SQL Server 2000. To install Microsoft SQL Server:

1. Select Install SQL Server 2000 Components.
2. Select Install Database Server. The InstallShield begins.
3. On the first screen, select Local Install. Click Next or Yes on the following screens until the Setup Type screen opens.
4. On the Setup Type screen, select Custom and click Next.
5. On the Select Components screen change or accept the default settings and click Next.
6. On the Character Set/Sort Order/Unicode Collation screen, in the Sort Order field, select Dictionary Order, Case Sensitive. Keep the other default settings and click Next.
7. On the Network Libraries screen, accept the defaults and click Next.
8. On the Services Accounts screen, select Use the same account for each service. Autostart SQL Server Service. For Service Settings, select Use the local system account. Then click Next.
9. Click Next until you reach the final screen and then click Finish when the installation is complete.

Creating a Database and Configuring Security

To create and configure a Microsoft SQL database, do the following:

1. From the Windows Start menu, select SQL Server – Enterprise Manager.
2. Expand SQL Servers.
3. Expand SQL Server Group.
4. Expand your host name (to get to the local databases).
5. Right-click Databases and select New Database.
6. Enter portal in the Name field and click OK.
7. Expand Security.
8. Right-click Logins and select New Login.
9. Enter portal in the Name field.
10. Select SQL Server Authentication and enter a password for the portal user.
11. For Defaults, select portal as the database.
12. Click the Database Access tab and select portal as the permitted database.
13. For Database roles for portal select:
    • db_ddladmin
    • db_datareader
    • db_datawriter
14. Select OK.
15. Because the default is blank, it is recommended that you change the password for the sa account.
    1. Click Logins.
    2. Right-click sa and select Properties.
    3. Enter a password and click OK.

Configuring Automatic Startup

To configure a Microsoft SQL database for automatic startup:

1. From the Windows Start menu, select Settings→Control Panel.
2. Open Services and double-click MSSQLServer.
3. For Startup Type, ensure that Automatic is selected.
4. For Log On As, select System Account.
5. Click OK.

Installing Microsoft SQL Server JDBC Driver

To install the Microsoft JDBC Driver, do the following:

1. Download the Microsoft SQL Server JDBC Driver from Microsoft: http://www.microsoft.com/sql/downloads
2. Install the JDBC Driver.
3. Copy the three JAR files within the lib directory where the driver was installed, to the %PORTAL_HOME%\class-custom directory (where %PORTAL_HOME% is the directory where enPortal was installed). There should be three JAR files, and they are named msbase.jar, mssqlserver.jar and msutil.jar.
4. Proceed with the steps to configure the database.

If the DBSetup utility is already running, you must re-start it so that it can successfully test the database connection.