Environment
Group Policy Administrator 5.x
Group Policy Administrator 6.x
Group Policy Administrator 6.x
Situation
Can I open more then one GPA repository from the same instance in GPA?
Why do I get the error: "Database connection already open" when trying to open a second GPO repository in GPA version prior to 5.0?
Why do I get the error: "Database connection already open" when trying to open a second GPO repository in GPA version prior to 5.0?
Resolution
This issue can be corrected two different ways. The secondary repository database can be moved to another SQL server, and then accessed from there, or a new SQL instance can be created on the local server and the Backup repositories moved to that location. To create these arrangements do the following steps:
- Run the SQL setup file
- Click Continue, Click Next
- Select weather you are creating the instance on the local SQL server ar a Remote server
- Click Next
- Select Create a new instance of SQL
- Click Next
- Make sure User and Company names are correct
- Click Next,Click Yes,Click Next
- In the textbox type in the new instance name
- Click Next
- On the setup screen select the options that have been layed out but your company
- Click Next
- Select which service account the server is going to run under
- Click Next
- Choose your autentication Moded, Windows integrated, or Mixed. If choosing mixed mode Type the SA account password in the textboxes
click Next,Click Next - Set your licensing Counter
- Click Next ,click Continue
- Click Finished
- Click Start
- All Programs Microsoft SQL Server Service Manager
- Under the server dropdown box select your newe instance name
- Click the start button
- Close the Service manager
- Now that the SQL instance has been created the Dabase needs to be attached to it for access.
Step 2
- Open the drive letter of the drive where SQL has been installed
- Program Files
- MS SQL Server
- MSSQL$<instance name>
- Data
- Copy your back up database to this location
- Close the window
- Open SQL Enterprise Manager
- Expand Microsoft SQL Server
- Right Click on SQL Server Group
- New SQL Server Registration
- Select the Instance in the left Pane and click Add
- Click Next
- Select your authentication mode
- Click Next,Click Next
- Click Finished
- Click Closed
- In the left Panel of Enterprise manager double click the new instance name
- Right click Databases
- All Task
- Attach Database
- Browse to the Drive location of the .MDF file
- Click OK
- In the attach as textbox place a name that this database will be known by
- Click OK
To bring the new linked database into GPA:
- Right click on GP Repository
- Select NEW Then Connect to Database
- Choose the server instance in the drop down menu
- In the Database Textbox type the name of the newly attached database
- Click OK
- Click OK
- You should now see the new Repository listing under GP Repository.
Cause
Older GPA did not support the use of named instances for multiple database connections; because of this the need to open several connections from a single instance was needed. GPA 5.0 and later changed the need for multiple connections from a single instance by bringing in support for named instance. With this change to GPA, the ability to use several data connectors to the same source is no longer available.
Additional Information
Formerly known as NETIQKB73244