Open topic with navigation
There was an error setting up the configuration database
Last Updated: 2010-07-26
- Guard1 Plus SE versions: 4.12, 4.20, 4.30, 4.40
When running the Guard1 Plus SE Database Setup Wizard (G1DBSetup.exe) you receive the following error:
- There was an error setting up the configuration database. Check the error log for details.
- The Guard1 Plus SE Local Client is not installed on the workstation where you are running the wizard
- There is a typo in the information you entered in the wizard
- The SQL Server authentication method is set to Windows Only
- The SQL Login associated to Guard1 Plus SE is configured incorrectly
- Insufficient permissions applied to the Guard1 Plus SE Server share and/or folder
- You have not created the Configuration database
On the workstation where you are running the G1DBSetup wizard, open the file C:\Program Files\Guard1 Plus SE\Error.log. Scroll to the bottom of the list and view the most recent errors.
- If the log shows ActiveX component could not create object: Install the Guard1 Plus SE Local Client on the workstation. If you have installed the Network Client, uninstall it then install the Local Client. After installing the Local Client, run the G1DBSetup wizard again.
- If the log shows SQL Server does not exist or access denied: re-run the G1DBSetup wizard and verify that you are typing the correct name for the SQL Server.
- If the log shows Login failed for user <LoginName>. Reason: not associated with a trusted SQL connection: Verify that the SQL Server authentication method is set to SQL Server and Windows(mixed mode), and that the Startup service account is set to System account. If the Startup service account is set to This account, verify that the specified account is valid and has Administrator privileges. If you make changes, restart the SQL Server Service, then delete the old SQL Login from the Guard1 Plus SE databases. Delete the old Login, then re-create it and associate it to your databases per the Guard1 Plus SE Administrators Manual. Re-run the G1DBSetup wizard.
- If the log shows Login failed for user <LoginName>:
- Re-run the G1DBSetup wizard and verify that you are typing the name of the Configuration database and the Login credentials correctly. NOTE: Login credentials are case-sensitive.
- If the same error recurs, verify the following for the SQL Login. If you make changes, save them, then delete the Login from both databases and re-add, then re-run the wizard.
- Authentication method is set to SQL Server Authentication.
- Default Database is set to master.
- You have assigned the Database Creator and Bulk Insert Administrator roles to the Login.
- If the same error recurs: On the PC where the Guard1 Plus SE Server share resides, browse to C:\Program Files\Guard1 Plus SE Server and delete the files Config.ini and Setup.ini (if present). Re-run the wizard.
- If the log shows Cannot open database requested in login Guard1PlusConfig. Login Failed.:
- Re-run the G1DBSetup wizard and verify you are typing the correct SQL Server name, SQL Login name, SQL Login password and Configuration database name.
- If the error recurs:
- Open SQL Enterprise Manager/Management Studio.
- Right-click the appropriate SQL Server instance and select Properties.
- Click the Security tab.
- Verify that Start and run SQL Server in the following account is set to System Account.
- If set to This account, verify that the specified account is valid and the password is correct.
- If you make changes, you must stop and restart the SQL Server Service.
- Verify that you have assigned "Modify" permissions for Everyone to the Guard1 Plus SE Server share and folder.
- Verify that you have created the Guard1 Plus SE databases "Guard1Plus" and "Guard1PlusConfig" on the SQL Server and configured them correctly. Refer to the Guard1 Plus SE Administrators Manual on your CD for more information.
Copyright © 2013-2016 TimeKeeping Systems, Inc.
Open topic with navigation