Post reply

SQL Server Analysis Server Cube Deployment Error

  • August 27, 2008 at 10:22 am

    #211663

    When I attempt to deploy an olap cube to the server, the following message occurs:

    Error3OLE DB error: OLE DB or ODBC error: Out-of-process use of OLE DB provider "SQLNCLI.1" with SQL Server is not supported.; 42000.00

    All of the underlying data used for the OLAP cube resides on SQL Server DB.

    Anyone run into this?

  • August 27, 2008 at 10:18 pm

    #864117

    hi,

    What version of Sql Server is you using?

    Regards

    Vijay

  • August 28, 2008 at 6:18 am

    #864281

    SQL Server 2005 with all RTM service packs installed.

  • August 28, 2008 at 6:23 am

    #864283

    hi,

    Check whether you can login to your Sql Server Analysis Service 2005 using windows authentication.Problably that is the problem area for you, since the error message is an connection based one.:)

    Thanks & Regards

    Vijay

  • August 28, 2008 at 9:30 am

    #864512

    The issue seems to be related to a second connections I set up for a dataset in another location. When I dropped that dimension and DSV, everything worked fine. Will need to play with that one some more.

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply