Receiving a 1001 error when trying to install Analysis Center DataWarehouse

  • 7012102
  • 09-Apr-2013
  • 17-Apr-2013

Environment

NetIQ Analysis Center 2.7.x
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.