Wednesday, December 15, 2010 12:10 PMError 5 OLE DB error: OLE DB or ODBC error: Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.; 28000; Cannot open database "ComsatsDWH" requested by the login. The login failed.; 42000. 0 0
i have server name "HSN" set for integration,analysis and reporting services
Wednesday, December 15, 2010 4:31 PMIs the HSN server remote? If so the local account will not be able to authenticate. Rather, use a Active Directory account that is able to authenticate remotely.
Advanced Computing - Business Intelligence and Information Strategies
Friday, December 17, 2010 8:08 AMModerator
It seems the Impersonation option you are using is ‘Service Account’, but the Services Account 'NT AUTHORITY\NETWORK SERVICE' doesn’t have permission to access to source database ‘ComsatsDWH’. So you have two options:
1) Change the Impersonation option, use a specific windows user name and password, of cause the account should have permission to access to ‘ComsatsDWH’.
2) In database ‘ComsatsDWH’, grant access permission to 'NT AUTHORITY\NETWORK SERVICE'. Actrually, if the SQL DB and SSAS on the same machine, you can also try to use local system as LogOn Account for SSAS.
Another similar thread you can refer to:
Hope this helps,
Raymond Li - MSFT
- Marked As Answer by mhassanshahbaz Friday, December 17, 2010 9:56 AM