Environment
NetIQ Analysis Center 2.7.x
Microsoft SQL Server 200x
Microsoft SQL Server 200x
Situation
Receiving a 1001 error when trying to install the DataWarehouse on SQL Server 200x. This can occur when 'query governor' is enabled on the Microsoft SQL Server
Resolution
To resolve this issue you need to do the following:
1- Connect to your Microsoft SQL Server you are wanting to install the DataWarehouse onto with SQL Server Management Studio
2- Right Click on SQL Server in treeview and select 'Properties'
3- Navigate to the 'Connections' page
4- Uncheck the box 'Use query governor to prevent long-running queries'
5- Click 'OK'
6- Restart the Analysis Center installation
Cause
'Query Governor' is used to not allow queries to run indefinetly. By default when selected the value would be '300' seconds. Any query running over 300 seconds will be halted.