SSAS Cube Deploy issue

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

  • 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…

Not yet verified

换了一种方法后 本地是可以Deploy了


I found the answer here on the MS SQL Server Forum for Analysis Services:

Solution for: OLE DB or ODBC error:Login failed for user NT Service\MSSQLServerOLAPService error – create new login in the SQL Server database engine so analysis services can read the data in the database being analyzed.

Create login and grant access:

Open up SQL Server Management Studio [login to the database engine]>
Security >
Login (Right click) >
New Login >add user: “NT Service\MSSQLServerOLAPService”>
select the database being analyzed in the drop-down list at the bottom >
User Mapping [click on the database in the list] >
In the window database role membership click on db_datareader [this grants access to read the data]

More details here

Hope this helps!

Shahfaisal Muhammed

Thank you everyone who helped me – thank you very much!

来源 Cube