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:
- Access the jTDS driver files at the following location: http://jtds.sourceforge.net/
- Download the file jTDS-1.2-dist.zip to your local file system.
- Locate the file jtds-1.2.jar within the downloaded zip file.
- 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:
- Select Install SQL Server 2000 Components.
- Select Install Database Server. The InstallShield begins.
- On the first screen, select Local Install. Click Next or Yes on the following screens until the Setup Type screen opens.
- On the Setup Type screen, select Custom and click Next.
- On the Select Components screen change or accept the default settings and click Next.
- 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.
- On the Network Libraries screen, accept the defaults and click Next.
- 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.
- 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:
- From the Windows Start menu, select SQL Server – Enterprise Manager.
- Expand SQL Servers.
- Expand SQL Server Group.
- Expand your host name (to get to the local databases).
- Right-click Databases and select New Database.
- Enter portal in the Name field and click OK.
- Expand Security.
- Right-click Logins and select New Login.
- Enter portal in the Name field.
- Select SQL Server Authentication and enter a password for the portal user.
- For Defaults, select portal as the database.
- Click the Database Access tab and select portal as the permitted database.
- For Database roles for portal select:
- db_ddladmin
- db_datareader
- db_datawriter
- Select OK.
- Because the default is blank, it is recommended that you change the password for the sa account.
- Click Logins.
- Right-click sa and select Properties.
- Enter a password and click OK.
Configuring Automatic Startup
To configure a Microsoft SQL database for automatic startup:
- From the Windows Start menu, select Settings→Control Panel.
- Open Services and double-click MSSQLServer.
- For Startup Type, ensure that Automatic is selected.
- For Log On As, select System Account.
- Click OK.
Installing Microsoft SQL Server JDBC Driver
To install the Microsoft JDBC Driver, do the following:
- Download the Microsoft SQL Server JDBC Driver from Microsoft: http://www.microsoft.com/sql/downloads
- Install the JDBC Driver.
- 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.
- Proceed with the steps to configure the database.