OLE DB or ODBC error: login failed for user "NT AUTHORITY \ NETWORK SERVICE

I am using SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio.

I create one project Business Intelligence Project

I create Data SourceOf Adventure Work 2008 DWand then create oneData Source View

and then I will create one Cube.

I can buildand rebuildmy project, but when I want Deploy, I get 34 errors.

First mistake

OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK 
SERVICE'.; 28000; Cannot open database "AdventureWorksDW2008" requested by the login.
The     login failed.; 42000.   

I find this link: SQL Server 2012: Login failed for user 'NT Service \ MSSQLServerOLAPService'; 28,000

but it does not work for me.

+4
source share
3

I , :

Data Source

enter image description here

Edit

enter image description here

enter image description here

use specific windows ...., SSAS.

enter image description here

+6

, ( ) "NT AUTHORITY\NETWORK SERVICE" SSAS Server. SSAS "" "NT AUTHORITY\NETWORK SERVICE" .

" SSAS": http://technet.microsoft.com/en-us/library/cc304417.aspx

, "NT AUTHORITY\NETWORK SERVICE" DW

+3

"NT AUTHORITY\SYSTEM" , "".

enter image description here

"NT AUTHORITY\SYSTEM" , " " ​​, < > . , . "".

enter image description here

+2

All Articles