Known Issues in Gallery Server Pro 1.0.1

Last updated February 13, 2007.

• Uninstalling Gallery Server Pro does not delete the SQL Server database. This applies only if you used the MSI install (GalleryServerPro101SetupMSI.msi). Workaround:
• The VBScript named dbsetup.vbs that installs the database stores the SQL login's password in clear text in a log file. This script is run during the MSI install (GalleryServerPro101SetupMSI.msi) or when you explicitly run dbsetup.vbs during an XCOPY installation (following the directions in step 7 of the Installation Guide). The password that is stored in the log file is associated with the run-time environment of Gallery Server Pro, and the only permissions it receives are to execute the Gallery Server Pro stored procedures within the Gallery Server Pro database. It is not the password you may have specified that provided permission to create the database. Nonetheless, it shouldn't be sitting around in clear text. Workaround: After running the MSI installation or executing dbsetup.vbs, delete the log file or delete the password from the log file. The log file is stored at %Program Files%\Gallery Server Pro\DatabaseSetup.log.
• MSI install does not report error during installation if the database script fails. If, during installation using the MSI version (GalleryServerPro101SetupMSI.msi), the VBScript that installs the database fails, the user is not notified. Instead, the user is incorrectly told the installation was successful. Workaround: If you suspect a problem with the installation, review the database script log to determine the error, correct it, and try again (Use Add/Remove Programs to remove Gallery Server Pro before trying to install it again). The log is located at %Program Files%\Gallery Server Pro\DatabaseSetup.log. For example, if the SQL Server password entered into the setup wizard does not satisfy the security requirement, the log will say so, and you will know to try the setup again using a stronger password.
• Cannot install using the MSI file on Vista with UAC turned on. If you try to install Gallery Server Pro on Vista using the MSI version (GalleryServerPro101SetupMSI.msi), you will receive the following error: "Gallery Server requires IIS 5 or higher, .NET Framework 1.1 and ASP.NET. One or more of these items is missing or not enabled. Please correct, then restart this installation".This is a known limitation of Wise for Windows 6.2. It's internal scripts do not have permission to check for proper versions of required components. Workaround: Use the XCOPY deployment to install Gallery Server Pro on Vista. The MSI installation may work with UAC temporarily turned off, but I haven't tested it.
• Issue when installing Gallery Server Pro when the database already exists. When installing Gallery Server using the MSI setup file, one of the wizard steps asks for the name of the database to be created. If you specify an existing Gallery Server Pro database that was created during a previous installation, the database is not re-created nor is the SQL login and password you specified in the wizard added to SQL Server. However, the SQL login and password is written to the web.config file. Therefore, if the SQL login and password did not previously exist in the database, the web app will fail with an authentication error. Workaround: Do one of these: (1) Edit the web.config file to specify a SQL login and password that already exists and has execute permission for the stored procedures in the Gallery Server Pro database. (2) Manually add the SQL login and password to SQL Server and give it permission to execute the stored procedures in the Gallery Server Pro database.