OLAP Processing job fails on step 8: SQL Server does not exist or access denied. (NETIQKB53226)

  • 7753226
  • 02-Feb-2007
  • 16-Mar-2011

Environment

NetIQ Analysis Center 2.x

Situation

OLAP Processing job fails on step 8: SQL Server does not exist or access denied.

OLAP Processing job fails when a data source is deleted or the Data Mart database is unavailable.

Error: 'Error [NetIQETL] EXCEPTION System.Runtime.InteropServices.COMException (0x80045703): [SQL-DMO][Microsoft][ODBC SQL Server Driver][SQL Server][DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. at SQLDMO._Database2.ExecuteImmediate(String Command, SQLDMO_EXEC_TYPE ExecType, Object Length) at NetIQ.CreateDatabase.SQLSCRIPT.Execute()SQL Statement Error'

Resolution

Restart the Microsoft SQL Server and Microsoft SQL Server Agent services on the Data Mart server and rerun the OLAP processing job.

Cause

The Data Mart is not available for continued processing of the data.

Additional Information

Formerly known as NETIQKB53226

Feedback service temporarily unavailable. For content questions or problems, please contact Support.