Page Comparison

...

• JDK 1.6 update 21 or later (JDK 1.7 is not supported as of 2012/04)
  • http://java.sun.com (openjdk works as well)
• Tomcat 6.X (Tomcat 7 is not supported as of 2012/04)
  • Download source, http://tomcat.apache.org
    • On Unix:
      • Tomcat is available in the package manager of most linux distributions.
      • Install it according to the distribution's instructions.
        • Ubuntu - https://help.ubuntu.com/11.10/serverguide/C/tomcat.html
    • On Mac:
      • Tomcat is available via the homebrew package manager or
      • Download at: http://tomcat.apache.org/download-60.cgi
    • On Windows:
      • Tomcat is available as a download at: http://tomcat.apache.org/download-60.cgi
• PostgreSQL 8 or later or Microsoft SQL Server 2005 or newer-SQL Server 2008 R2
  
  • PostgreSQL
    
    1. Download source http://www.postgresql.org
       • On Unix:
         • PostgreSQL is available in the package manager of most linux distributions.
         • Install it according to the distribution's instructions
         • Ubuntu - https://help.ubuntu.com/11.10/serverguide/C/postgresql.html
       • On Mac:
         • PostgreSQL is available via the homebrew package manager or as a download on the postgresql.org site.
       • On Windows:
         • PostgreSQL is available as a download on the postgresql.org site.

    2. Configure PostgreSQL

       1. Connect via pgadmin or your preferred db admin tool

       2. Create the "ssp" & "sspadmin" users and the "ssp" database.

  • Microsoft SQL Server 2005 or newer
    • JDBC Driver
      1. Download the Microsoft SQL Server JDBC driver from http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx
      2. Rename the downloaded file extension from .exe to .zip. Unzip the sqlserver-jdbc4-3.0.jar file to a directory of your choice.
      3. Place the JAR file in the Tomcat shared library directory. ($CATALINA_BASE/shared/lib or $CATALINA_BASE/lib)
    • Server Connection
      1. Launch the SQL Server Management Studio application
      2. Enter your database connection info including administrator account credentials, and click Connect
    • Login Roles
      1. Navigate to Security->Logins, and right click on New Login
         

         1. Login name of "sspadmin" without the quotes

         2. Select SQL Server authentication and enter a Password of "sspadmin" without the quotes

         3. Uncheck Enforce password policy

         4. Click OK

      2. Right click on Logins again, and New Login Role

         1. Login name of "ssp" without the quotes

         2. Select SQL Server authentication and enter a Password of "ssp" without the quotes

         3. Uncheck Enforce password policy

         4. Click OK

      3. Confirm the new users exist
    • Database
      1. Navigate to and right click on Databases and click New Database
         1. Enter "ssp" without the quotes as the database name
         2. Click OK
      2. Confirm the new database exists
      3. Run the following SQL to associate the new user accounts with the correct permissions on the new database:

         • USE [ssp]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY') ALTER DATABASE [ssp] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO
IF NOT EXISTS (SELECT name  FROM sys.database_principals WHERE name = 'ssp')
BEGIN
CREATE USER [ssp] FOR LOGIN [ssp]
EXEC sp_addrolemember N'db_datawriter', N'ssp'
EXEC sp_addrolemember N'db_datareader', N'ssp'
END
GO
CREATE USER [sspadmin] FOR LOGIN [sspadmin]
GO
EXEC sp_addrolemember N'db_owner', N'sspadmin'
GO

...