Login failed for user when Deploying CUBE
-
Thursday, February 14, 2013 7:12 AM
I have SQL Server 2012 Analyses Services running with account 'DOMAIN\sql_2012_as'.
I have SQL Server Database and account 'DOMAIN\sql_2012_as' and 'DOMAIN\Admin' have dn_owner rights.
Impersonation Setting for Data Source in VS is Inherit. I have opened VS with account DOMAIN\Admin.
I get following errors:
Error 7 OLE DB error: OLE DB or ODBC error: Login failed for user 'DOMAIN\sql_2012_as'.; 28000.
Error 8 Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of DataBaseName, Name of 'DataBaseName CBA'.
Kenny_I
All Replies
-
Thursday, February 14, 2013 4:39 PM
Hi Kenny,
Please read the marked answer in this link - http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/62e56047-442e-4d6e-9aa3-a3ae6a52e206
Under SolutionExplorer -> double-click on .ds file -> Impersonation Information
Thanks & Regards, sathya
- Edited by SathyanarrayananS Thursday, February 14, 2013 4:43 PM
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 2:38 AM
-
Thursday, February 14, 2013 6:20 PMModerator
Hi,
Use the SSAS Service account(impersonation = service account) and check that this account has read permissions(data reader permissions in SQL Server RDBMS).
HTH
Thomas Ivarsson
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 2:38 AM
-
Monday, February 18, 2013 8:29 AMModerator
Hi Kenny,
Here is a similar thread about this topic for your reference, please see:
http://social.technet.microsoft.com/Forums/en-US/sqlanalysisservices/thread/ece211cf-ba37-49bf-a8c1-78cddfe05bc5/Please let us know if you have any more questions.
If you have any feedback on our support, please click here.
Regards,
Elvis Long
TechNet Community Support
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Monday, February 25, 2013 2:38 AM
.png)
