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

Question

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 1

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.

Answer 2

1-Run "SQL Server Configuration Manager"

2-Select "SQL Server Services"

3-Right Click "SQL Server Analysis Services" and choose properties

4-On the "log on " tab ,choose "this account".

5-Click "Browse" button , then Click "Advanced" button.

6-Click "find now" button . Now find your account in the below table and select it.

7-When you selected proper account (With sufficient permission) , return to "log on" tab

and enter your password

8-Restart service and try again your task...

I hope this could help ...

Answer 3

I found my solution using the oposite logic of Amir.

• Run "SQL Server Configuration Manager"
• Select "SQL Server Services"
• Right Click "SQL Server Analysis Services" and choose properties.
• On the "log on " tab ,choose "Built-In Account".
• Finally select "Local System".

Though I am just running things locally to make modifications that will later be pushed to production. So if you're running locally, this solution may help.