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.
source
share