Does Group Policy Administrator (GPA) support Microsoft SQL Server 2005 Express Edition? (NETIQKB52140)

goal
Does Group Policy Administrator (GPA) support Microsoft SQL Server 2005 Express Edition?

fact
NetIQ Group Policy Administrator 5.0

symptom
Error:"To complete this installation, you must be a member of the SQL Server sysadmin role."

symptom
"To complete this installation you must be a member of the SQL Server Sysadmin role.  Please add your user account to the Sysadmin role and then continue with the installation.  Alternatively, log on to this computer with a user account that is a member of the Sysadmin role to perform the installation."

symptom
Error installing the GPA console on Windows XP workstation with SQL 2005 Express installed.

cause
The GPA Console supports only default instances of Microsoft SQL Server 2005 Express Edition. However, the standard installation of Microsoft SQL Server 2005 Express Edition installs a named instance of SQL Server, not a default instance. If you have a named instance of Microsoft SQL Server 2005 Express Edition, you must install another, default instance to successfully install the GPA Console.

fix

Use the following procedure to install a default instance of Microsoft SQL Server 2005 Express Edition. You can follow these steps whether you are installing Microsoft SQL Server 2005 Express Edition for the first time or have already installed a named instance.

To install a default instance of Microsoft SQL Server 2005 Express Edition:

1. Run the Microsoft SQL Server 2005 Express Edition setup program.
2. Accept the license terms and conditions, and then click Next.
3. If you are installing Microsoft SQL Server 2005 Express Edition for the first time, click Install, and then click Next.
4. If you have already installed a named instance of Microsoft SQL Server 2005 Express Edition, click Next.
5. Click Next, and then click Next again.
6. Clear the Hide advanced configuration options check box, and then click Next.
7. Select the program features you want to install, and then click Next.
8. Select Default instance, and then click Next.
9. Specify the service accounts to use for the SQL Server services and the services you want to start at the end of the installation, and then click Next.
10. Choose the authentication mode you want to use, and then click Next.
11. Choose the collation method to use for the SQL Server service, and then click Next.
12. Choose whether to enable user instances, and then click Next.
13. Select the error and usage report settings you want, and then click Next.
14. Click Install.
15. Click Next.
16. To complete the installation, click Finish.

note
Note: This information can also be obtained from the GPA 5.0 Release Notes.

Formerly known as NETIQKB52140