Novell Home

My Favorites

Close

Please to see your favorites.

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

This document (7773244) is provided subject to the disclaimer at the end of this document.

Environment

Group Policy Administrator 5.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?

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:

  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.

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

Disclaimer

This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.

  • Document ID:7773244
  • Creation Date:10-NOV-11
  • Modified Date:10-NOV-11
    • NetIQGroup Policy Administrator

Did this document solve your problem? Provide Feedback