Post reply

deploying a cube

  • December 17, 2012 at 8:51 am

    #286229

    Hi

    I am having trouble deploying a cube, this seems to be the main error i am getting

    OLE DB error: OLE DB or ODBC error: Login failed for user 'username'.; 28000.

    In the Impersonantion Information I am using the service account (although im not 100% sure why), the username given in the error isnt the service account as far as i can see, how do i change this? is there another method i can use that is better?

    thanks in advance

  • December 17, 2012 at 1:23 pm

    #1569264

    Is the account you're running BIDS under on the admin list for the SSAS instance?

    Is the account with the error the account you're running BIDS under?


    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]

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

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