Installing PSQL Workgroup for Windows
 
Installing PSQL Workgroup for Windows
Instructions for Installing the PSQL Workgroup Engine on Windows
The following topics cover installation of PSQL Workgroup:
Before You Install PSQL Workgroup
Installing PSQL Workgroup for Windows
Where to Go from Here
Before You Install PSQL Workgroup
Before you install any edition of PSQL, you should be familiar with the following information:
Preparing to Install PSQL – Important information including system requirements and platform specific notes that are relevant to your operation.
Release Notes – The release notes are located in readme_psql.htm on the distribution media and contain late-breaking news that could not be included in the user documentation.
Installation Tips
When installing PSQL for the first time on a system, the installer checks whether all needed system files meet minimum requirements. In some cases, these files are locked by the operating system and a restart is required before the installer can continue. Click Yes to restart the system. The installer is then automatically restarted.
It is strongly recommended that you restart your system if you encounter this message. If you do not restart your system, the installer encounters failures during engine and utilities configuration.
If you have any trouble with the following installation, see Troubleshooting After Installation.
Installing PSQL Workgroup for Windows
The following steps explain how to install PSQL Workgroup from its media using the default interactive installation.
After you run the installer, you can find the installation log file in the Windows %Temp% directory. This log may be useful if the installation fails.
To install PSQL Workgroup for Windows
1 Launch the PSQL installer from your Windows machine in one of the following ways:
Download and run the installer.
Insert the PSQL CD into the CD-ROM drive. If the installer does not start automatically, then open the CD root directory and run autorun.exe.
2 In the installer selection list, click Workgroup Edition to install its 32-bit components.
3 If prompted, close or uninstall any running applications that may interfere with PSQL installation. If you wish to leave any of these programs running, you must click Ignore to continue. However, unpredictable behavior may occur during PSQL installation that cause it to fail.
4 In the Welcome screen, click Next.
5 On the License Agreement page, read and accept the Software License Agreement, and then click Next.
6 Choose the type of installation:
Select the default Run as a Service if either or both of the following is true:
You want to avoid User Access Control (UAC) conflicts in the operating system. Running the engine as a service requires the Log On as Service privilege. If you run the engine as a service under a user account other than the default Local System account, in the Control Panel be sure to modify the properties in the Log On tab for both PSQL services.
You want to run Workgroup Engine in a Terminal Services environment.
Select Run as an Application if:
The data files reside on a remote machine, are accessed via mapped drives, and no database engine is running on the remote machine.
7 Select one of the following setups:
Complete setup is recommended for most users. It installs all PSQL components using the default options and locations. If you choose this setup, click Next and continue with step 12.
Custom setup is for advanced users. It allows you to choose installation locations and control the number of PSQL components installed. If you choose Custom, continue with the next step.
8 To choose different installation locations, click Change for any of the directories listed. When you have made your choices, click OK.
9 Click Next to continue.
10 By default, all PSQL components and features are selected for installation. If needed, select from the following items to exclude them from installation and click Next.
Data Access
ActiveX Interface Controls
ADO.NET Providers
Btrieve DOS (32-bit only)
DTO/DTI
JCL
JDBC Driver
OLE DB
PDAC
Utilities
Java Utilities
PSQL Control Center (PCC)
Documentation plug-in for PCC
Data Dictionary File Builder
Notification Viewer
Other Utilities
Cobol Schema Executor
PSQL System Analyzer
11 Click Next to continue.
12 Click Install to begin the installation.
13 Once the installation is complete, the wizard indicates that it was successful. The product has been installed with a trial key that expires at the end of its trial period.
You have two choices at this point: Authorize the product now with a permanent key or end the installation and authorize the product later.
If you choose to authorize the product now, an Internet connection is required. Click Next and continue with the next step. If you have no Internet connection, click Next and then click Finish. See Alternative Authorization Tasks in PSQL User's Guide.
If you choose to end the installation at this point, click Next and then click Finish. You may run the License Administrator utility at any time to authorize a key. See License Administration in PSQL User's Guide. See also Authorization of Workgroup Key on Windows with UAC.
14 Enter your license key and click the button to authorize the key.
If you decide not to authorize the product at this point, click Finish. You may run the License Administrator utility at a later time to authorize a key. See License Administration in PSQL User's Guide.
15 A message box displays the status of the authorization action. Perform one of the following actions depending on the status:
If the authorization status message is “key is authorized,” click OK, then click Finish to complete the installation.
If the authorization status message reports an error or warning, click OK and repeat the step to enter a valid license key.
16 We recommend that you register your product as explained in the Registration page that opens.
If you are prompted to restart your system, please do so to ensure proper operation of your PSQL product.
Note The installer modifies selected system environment variables.
Authorization of Workgroup Key on Windows with UAC
You can encounter difficulty authorizing a permanent key for PSQL Workgroup on Windows with User Account Control (UAC) if the following conditions are all true:
PSQL Workgroup was installed as an application.
The Workgroup database engine is running without administrative privileges. Note that, by default, applications run with privileges of a standard user unless the privileges are elevated. That is, even if you are a member of the administrator group and you start the Workgroup database engine without using Run as Administrator to elevate privileges, the engine runs with privileges of a standard user.
A permanent key for PSQL Workgroup was not supplied during the installation process. That is, you chose to authorize the permanent key after installation by using a licensing utility.
Complete the following steps to ensure a permanent key is correctly authorized:
1 If the PSQL Workgroup application is running, close the application (stop the database engine by right-clicking on the engine tray icon then clicking stop).
2 From File Explorer, locate the file w3dbsmgr.exe. In a default 64-bit installation, it is found in C:\Program Files (x86)\Actian\PSQL\bin.
3 Right-click w3dbsmgr.exe and select Run as Administrator. You must have administrative rights or know the name and password of a user with administrative rights. You need to elevate the privileges of the database engine before authorizing a key with a licensing utility.
4 Start License Administrator from operating system Start menu or Apps screen (or use the command line interface licensing utility if you prefer).
5 Type, or paste, the permanent key for PSQL Workgroup in the Key field, then click the button to authorize the key.
6 Optionally, stop the database engine and restart it without elevated privileges.
Note that elevating the privileges for a license administrator utility is not the solution. The database engine itself, w3dbsmgr.exe, is what requires elevated privileges.
Where to Go from Here
A proper configuration is essential to smooth operation of your PSQL Workgroup engine. See Setting Up the Workgroup Engine for detailed information on how to do this task.