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

sql sql-server sql-server-2008-r2 ssas olap
Ardalan Shahgholi picture Ardalan Shahgholi · Oct 20, 2013 · Viewed 24.8k times · Source

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.

Answer

Ardalan Shahgholi picture Ardalan Shahgholi · Jan 20, 2014

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

Related questions

DateAdd Column caused an overflow

After executing the following query I am getting an error Adding a value to a 'datetime' column caused an overflow. I have no idea why this is happening as it worked smoothly for a couple of weeks. I am just …

Read More
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More