An error occurs when attempting to add a domain to the repository. (NETIQKB28194)

fact
NetIQ Group Policy Administrator 3.0

symptom
An error occurs when attempting to add a domain to the repository.

symptom
Error: 'Invalid Active Directory path passed'.

cause
This problem may occur if there are multiple instances of Microsoft SQL running and the database holds a NULL value for the server name; because of which, the Repository is unable to capture the server name.

fix

The above described problem can be resolved by performing the following steps:

1. Launch Query Analyzer located under Start | Program Files | Microsoft SQL Server.
   
2. Run the following command in the Query window:
   
   sp_AddServer 'servername', local
   
3. If an error is returned , run the following command in the Query window:
   
   sp_dropserver 'servername'
   
4. Then re-run the following command in the Query window:
   
   sp_AddServer 'Servername', local

After performing the above steps launch the NetIQ Group Policy Administrator and add the domain to the Repository. 

Formerly known as NETIQKB28194