SQL Server Q&A

Symptoms
Analysis Server may stop and then restart when you browse cube data if the underlying data source is SQL Server and the data access is performed by using the OLE DB provider for SQL Server. Therefore, cube browsing from the cube browser may fail.
Resolution
When the query that is generated by Analysis Manager is too large, the SQL Server provider returns success for the status of the query and NULL for the pointer. The NULL value for the pointer causes Analysis Services to stop and then restart.

Symptoms
When you bind a DateTimePicker control to a data source, you may receive the following error message:

An unhandled exception of type ‘System.InvalidCastException’ occurred in mscorlib.dll
Additional information: Object cannot be cast from DBNull to other types.
Resolution
This behavior occurs if the field that is bound to the DateTimePicker control contains a null value that is represented by the System.DBNull object. The DateTimePicker control does not support the System.DBNull object.

Symptoms
You run Report Manager in Microsoft SQL Server 2008. When you try to use Microsoft SQL Server Analysis Services as a data source for a data-driven subscription, you receive the following error message:

The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery) Get Online Help The type initializer for ‘module’ threw an exception.The C++ module failed to load while attempting to initialize the default appdomain.Access is denied. (Exception from HRESULT: 0×80070005 (E_ACCESSDENIED))
Resolution
This problem occurs if SQL Server Analysis Services is not installed in the location that is expected by the SQL Server Reporting Services service.