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. ?I was very happy to search out this net-site.I wished to thanks on your time for this excellent learn!! I positively enjoying each little little bit of it and I have you bookmarked to take a look at new stuff you weblog post. online casino real money

    ReplyDelete