Appboard/old/configuration database/example mssql: Difference between revisions

imported>David.moore
(Created page with '{{DISPLAYTITLE:Microsoft SQL Server}} This section describes the following tasks that must be performed in order to use SQL Server with enPortal: === Downloading the Microsoft …')
 
imported>David.moore
No edit summary
Line 13: Line 13:
#Locate the file jtds-1.2.jar within the downloaded zip file.
#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/
#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.

Revision as of 20:08, 25 November 2013


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.