Saturday, September 22, 2012

OLE DB or ODBC error:Login failed for user NT Service\MSSQLServerOLAPService


You might get the error: OLE DB or ODBC error: Login failed for user 'NT Service\MSSQLServerOLAPService' when processing a cube/dimension. Here is what causes this error and how you can resolve the problem:

SQL Server Analysis Services will use the service account(by default) to pull data from the data source (the database server that hosts the data). If your Analysis Services instance is running under the account 'NT Service\MSSQLServerOLAPService', then this account will be used(by default) to read data from the databases and if the account doesn't have read access, you will get the above error. To resolve this, just grant the account read access to the relational database(s) you are trying to pull data from.

Also, please note that it is recommended to setup the data sources to use a domain account and to setup Analysis Services to run under a domain account. More details on data source impersonation options can be found here - http://technet.microsoft.com/en-us/library/ms187597.aspx


2 comments:

  1. Couldn't be written any better. Reading this post reminds me of my old room mate! He always kept talking about this. I will forward this article to him. Pretty sure he will have a good read. Thanks for sharing!


    Macy
    www.gofastek.com

    ReplyDelete
  2. I really love your blog there's a lot to share. Keep it up.Visit my site too.

    n8fan.net

    www.n8fan.net

    ReplyDelete