Skip to main content

 Installation

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.

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 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 through 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 the “Protocols for SQLEXPRESS” node under “SQL Server Network Configuration”.
  3. Right click “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 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 Status and select “Grant” and “Enable”.
  5. Click OK.

PageSeeder performs the rest of the database setup automatically as part of the Setup process using the following default settings, 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 the SQL Server instance you are going to use for PageSeeder.
  3. Right click 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 Security under your SQL Server instance.
  6. Right click Logins and select New Login.
  7. Enter the following login details. Substitute your own password for <password> (this is the password you need to enter in the PageSeeder Setup):

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