Category: BI\DW\SSAS

How create a Cube on SSAS

https://msdn.microsoft.com/zh-cn/library/ms170400.aspx

English Version: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/creating-multidimensional-models-using-sql-server-data-tools-ssdt

Advertisements

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

stackoverflow.com

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

SOLUTION FOUND

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 http://msdn.microsoft.com/en-us/library/ms189751.aspx

Hope this helps!

Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com

http://shahfaisalmuhammed.blogspot.com/2012/09/login-failed-for-mssqlserverolapservice.html

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

来源 Cube