Installing and configuring the EPS to use SQL Server as the database
To install the EPS with SQL Server as the database used to store information you should follow these steps;
- Download and install the EPS from http://www.enterprise-password-safe.com/download.html.
- Download and install or extract the JDBC driver from Microsofts JDBC Driver download page at http://www.microsoft.com/downloads/details.aspx?FamilyID=6d483869-816a-44cb-9787-a866235efc7c&DisplayLang=en.
- Ensure the EPS is not running.
- Copy any files ending .jar which were installed or extracted from the JDBC Driver to the ext directory in the jetty directory in your chosen EPS installation directory.
- Start the EPS.
- Navigate to the EPS login page and log in using the username admin and the password admin.
- Select the Database option from the menu on the left of the page.
- Select SQL Server 2005 as the database type from the drop down list. Please note, even if you are
using a SQL Server 2000 database you should select SQL Server 2005 because you will be using the SQL Server
2005 JDBC Driver.
- Alter the JDBC URL to reflect your environment. The URL is constructed as follows;
jdbc:microsoft:sqlserver://[MACHINE_NAME]:1433;DatabaseName=[DATABASE_NAME];SelectMethod=cursor
where [MACHINE_NAME] is the hostname of the server you are running the EPS on, and [DATABASE_NAME] is the name of the database you wish to store the EPS in. - Enter the username and password for a user which has full rights over the database.
- Ensure the Initialise database box is checked.
- Click the Set Values button. You will be logged out of the EPS.
- Log into the EPS again using the username admin and the password admin.
- Verify the change has been stored by selecting the Details option from the menu on the left of the page and ensuring that the Database shown is SQL Server.
Your EPS installation will now use SQL Server to store all of it's data.