Can I open more then one GPA repository from the same instance in GPA? (NETIQKB73244)

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?

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:

1. Run the SQL setup file
2. Click Continue, Click Next
3. Select weather you are creating the instance on the local SQL server ar a Remote server
4. Click Next
5. Select Create a new instance of SQL
6. Click Next
7. Make sure User and Company names are correct
8. Click Next,Click Yes,Click Next
9. In the textbox type in the new instance name
10. Click Next
11. On the setup screen select the options that have been layed out but your company
12. Click Next
13. Select which service account the server is going to run under
14. Click Next
15. Choose your autentication Moded, Windows integrated, or Mixed. If choosing mixed mode Type the SA account password in the textboxes
    click Next,Click Next
16. Set your licensing Counter
17. Click Next ,click Continue
18. Click Finished
19. Click Start
20. All Programs Microsoft SQL  Server Service Manager
21. Under the server dropdown box select your newe instance name
22. Click the start button
23. Close the Service manager
24. Now that the SQL instance has been created the Dabase needs to be attached to it for access.

Step 2

1. Open the drive letter of the drive where SQL has been installed
2. Program Files
3. MS SQL Server
4. MSSQL$<instance name>
5. Data
6. Copy your back up database to this location
7. Close the window
8. Open SQL Enterprise Manager
9. Expand Microsoft SQL Server
10. Right Click on SQL Server Group
11. New SQL Server Registration
12. Select the Instance in the left Pane and click Add
13. Click Next
14. Select your authentication mode
15. Click Next,Click Next
16. Click Finished
17. Click Closed
18. In the left Panel of Enterprise manager double click the new instance name
19. Right click Databases
20. All Task
21. Attach Database
22. Browse to the Drive location of the .MDF file
23. Click OK
24. In the attach as textbox place a name that this database will be known by
25. Click OK

To bring the new linked database into GPA:

1. Right click on GP Repository
2. Select NEW Then Connect to Database
3. Choose the server instance in the drop down menu
4. In the Database Textbox type the name of the newly attached database
5. Click OK
6. Click OK
7. You should now see the new Repository listing under GP Repository.
   

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.

Formerly known as NETIQKB73244