Search code examples
sqlsql-serversql-server-2008-r2ssasolap

OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE

I use SQL Server 2008 R2 and SQL Server Business Intelligence Development Studio.

I create one project of Business Intelligence Project

I create a Data Source Of Adventure Work 2008 DW and then i create one Data Source View

and then i create one Cube.

I can build and rebuild my project but when i want Deploy i get 34 error.

First error is

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'.; 28000

but it not work for me.

Solution

  • I Fix this error with verify this way :

    At First open Data Source

    enter image description here

    Then Edit connection string

    enter image description here

    enter image description here

    And then I use specific windows .... because I Want connect to another server for access to my SSAS.

    enter image description here