PageSeeder installation and upgrade instructions

Instructions for Microsoft SQL Server 2008 Express


PageSeeder has been deployed on SQL Server with zero problems for many years. However, due to lack of demand, the current version of PageSeeder has not been tested with SQL Server. We have left this documentation on the site in case it helps anyone but be aware that it is not current.

Please let us know if you are specifically interested in SQL Server support. We would welcome the opportunity to refresh PageSeeder's support for the SQL Server environment.

These instructions assume you have already installed SQL Server.

Enable SQL Server and Windows (mixed) authentication

SQL Server based authentication must be enabled on your SQL Server so that PageSeeder can access it using an SQL Server account.

To do this in SQL Server 2008 Express:

  1. Launch the SQL Server Management Studio.
  2. Right click on your SQL Server instance and select Properties.
  3. Select the Security tab.
  4. Select 'SQL Server and Windows Authentication mode'.
  5. Click OK.
  6. Finally, restart SQL Server from the Services control panel.

Enable TCP/IP Connections

TCP/IP connections must be enabled in SQL Server to allow PageSeeder to connect via a JDBC driver.

To do this in SQL Server 2008 Express:

  1. Launch the SQL Server Configuration Manager from the "Microsoft SQL Server 2008 > Configuration Tools" Program menu.
  2. Click on the "Protocols for SQLEXPRESS" node under "SQL Server Network Configuration".
  3. Right click on "TCP/IP" in the list of Protocols and choose, "Enable".

Enable the 'sa' account

In the standard PageSeeder install, in the Setup page, the Admin Login needs to use an 'sa' account to create the PageSeeder database. If you prefer not to do this, you can create the database manually (see next section).

Otherwise, to do this in SQL Server 2008 Express:

  1. Launch the SQL Server Management Studio.
  2. Right click on the 'sa' account under Security > Logins and select Properties.
  3. If you don't know the 'sa' password, you can change it here by entering a new Password and Confirm Password.
  4. Click on Status and select "Grant" and "Enable".
  5. Click on OK.

PageSeeder will perform the rest of the database setup automatically as part of the Setup process using the default settings below, however, these should be reviewed by your DB administrator who can if required execute these commands manually using settings appropriate to your database usage.

Creating the PageSeeder database (not required for standard install)

These instructions are a step by step guide to creating the PageSeeder database on Microsoft SQL Server 2000. They assume that you have already installed SQL Server. As stated above they are not required for a standard install.

  1. From the Start menu, select Programs>Microsoft SQL Server>Enterprise Manager.
  2. Double click on the SQL Server instance you will be using for PageSeeder.
  3. Right click on Databases under your SQL Server instance and select New Database.
  4. For name, type in pageseeder then click OK.
  5. In the Enterprise Manager, double click on Security under your SQL Server instance.
  6. Right click on Logins and select New Login.
  7. Enter the login details below. Substitute your own password for <password> (this is the password you will need to enter in the PageSeeder Setup):

    Login Name: pageseeder
    Click on SQL Server Authentication
    Password: <password>
    Default Database: pageseeder
  8. Select the Database Access tab and make the following selections:
    1. Click on the check box, in the Permit column next to PageSeeder (in the list of possible databases),
    2. Click on the check box next to db_owner.
  9. Click on OK and enter <password> again to confirm.

Created on , last edited on