Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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.

like image 678
Ardalan Shahgholi Avatar asked Oct 20 '13 12:10

Ardalan Shahgholi


3 Answers

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

like image 81
Ardalan Shahgholi Avatar answered Oct 19 '22 10:10

Ardalan Shahgholi


This error is regarding "NT AUTHORITY\SYSTEM", so just go to relational database and expand Security folder.

enter image description here

Double click on "NT AUTHORITY\SYSTEM", it will open "Login Properties" wizard, go to "User Mapping" tab and choose the relational database that you are going to use. Give appropriate permissions and click OK.

enter image description here

like image 4
KhiLan PaTeL Avatar answered Oct 19 '22 10:10

KhiLan PaTeL


I'm guessing that user (account) 'NT AUTHORITY\NETWORK SERVICE' don't have rights to SSAS Server deploy cube. Try open in SSAS instance and in properties choose 'Security' and add user 'NT AUTHORITY\NETWORK SERVICE'.

Example 'SSAS Server Role': http://technet.microsoft.com/en-us/library/cc304417.aspx

Of course it would be very interesting to see you rights of account 'NT AUTHORITY\NETWORK SERVICE' in your DW database

like image 3
Justin Avatar answered Oct 19 '22 11:10

Justin