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

Question

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.

score 7 · Accepted Answer · answered Jan 20 '14 at 07:33

7

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

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

enter image description here

answered Jan 20 '14 at 07:33

Ardalan Shahgholi

11,967
21
108
144

Try select **Use Windows Authentication** in the **Connection Manager** window, and try again, this solved my problem. – Max Meng Apr 23 '15 at 07:39

score 4 · Answer 2 · answered Oct 11 '15 at 01:45

4

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

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.

answered Oct 11 '15 at 01:45

KhiLan PaTeL

123
2
4

I had the same problem and your solution was really effective! Thanks – Dodi Nov 12 '17 at 12:08

score 3 · Answer 3 · answered Oct 22 '13 at 08:39

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

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

3 Answers3