SQL Server 2012: Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000

sql-server ssas
Manoj G picture Manoj G · Mar 6, 2013 · Viewed 67.2k times · Source

I am using Analysis services in Microsoft SQL Server 2012 on Windows 7.

I tried to create Mining models and process it. I am getting the following error while processing it.

OLE DB error: OLE DB or ODBC error:
Login failed for user 'NT Service\MSSQLServerOLAPService'.; 28000.

How to correct this and process the model successfully?

Answer

Inus C picture Inus C · Mar 6, 2013

I recently encountered a similar error.

My error was fixed by creating a new login in ssms, with the name the error gave me.

In your case it would be 'NT Service\MSSQLServerOLAPService'

You then need to check 'db_datareader' and the 'db_datawriter' in that new login's properties on the 'User Mappings' page. Check the database you are using on top and then the 'db_datareader' and 'db_datawriter'on the bottom where it sais 'Database Role Membership For: Database_Name.

Hope this helps.

Something you can also try is: Go to the 'Server Manager','Configuration','Services' Search for the 'SQL Server Analysis Services (Instance_Name)' that you use. Go to its Properties and then the 'Log on' tab. If it uses the option of 'This Account', make sure you use that account specified in the data source of the cube in the 'Impersonation Information' as the user name and password.

EDIT

The reason for this usually is because the account running the service does not have the right permissions to do what is requested.

There are 2 ways to do this so far I know:

  1. Change the account running the sevice to the account that has the right permissions.
  2. Give the account that is running the service the right permissions.

Related questions

SSAS MDX WHERE clause syntax - filtering multiple values from the same hierarchy

I'm quite new to data warehousing and MDX queries, and I realize that I'm probably not using the MDX syntax properly in the case below. I'm using SSAS 2005 on MS SQL Server 2005 and would like to query my cube and …

Read More
SQL Server Analysis Services - Do I have it?

Hi I have access to SQL Server at work and I've heard some interesting things that can be done with SQL Server Analysis Services. How do I know whether analysis services is running? Is it installed by default on the …

Read More
deployment of adventureworks cube fails: 'user does not have permission to create a new object in 'GARY-PC' or the object does not exist

when I deploy adventure works cube it fails, and i get: user does not have permission to create a new object in 'GARY-PC', or the object does not exist. trying to process cube from adventureworks DW and having what seem …

Read More