Why is MSDE required when I install the Group Policy Administrator 4.x console?
Do I need the Microsoft Data Engine to run the GPA user interface?
NetIQ Group Policy Administrator 4.x
NetIQ Group Policy Administrator 5.0
In Group Policy Administrator (GPA) version 3.0 and earlier, Crystal Reports generated the report of Group Policy Objects. Crystal Reports has limitation such as maximum size for reports. If other products using Crystal Reports are installed on the computer, the DLL versions conflict and the reports in GPA do not function.
GPA 4.x and later provides a proprietary database-driven reporting component. When you install the console, you also install the FA_GP_Studio database that caches GPO settings for the HTML reports in the user interface. The FA_GP_Studio database uses the Microsoft Data Engine (MSDE).
Beginning in NetIQ Group Policy Administrator 5.0 the GPA Console is no longer limited to Microsoft SQL Desktop Engine 2000 (MSDE). It now supports many different versions of Microsoft SQL Server:
- Microsoft SQL Server 2000 Personal Edition
- Microsoft SQL Server 2000 Service Pack 3 or later
- Microsoft SQL Server 2005 Standard, Enterprise, or Express Edition
- MSDE 2000
Note: The NetIQ Group Policy Administrator 5.0 Console supports only the default instance of Microsoft SQL Server. The NetIQ Group Policy Administrator 5.0 Console does not support named instances or Microsoft SQL Server clusters.