Return
-
Title
Creating Database with a different name results in an error -
Description
When following the steps in the user guide to create a database with a different name to "GPOADmin" it finishes with an error. If the database is then set in GPOADmin it will attempt to upgrade and fail with the following error:
-
Cause
The steps in the user guide to create the database using the GPOADmin.sql script included with GPOADmin are incorrect as they state the database name needs to be changed in two places, however it actually needs to be set in four. -
Resolution
Recreate the database using the GPOADmin.sql script, making changes as follows:
- Detach any databases that were created and failed from SQL
- In SQL management studio, open GPOADmin.sql from the installation directory on the GPOADmin server.
- Change the database name from [GPOADmin] to the required name on lines 3, 5, 12793 and 12796
Note: DO NOT CHANGE @value=N'GPOADmin'
- Run the script to create the database and then follow the instructions from step 2 in the user guide here.
-
Defect ID
VSTS000238963