I installed analysis services/ reporting services on SQL 2014 server and then restored databases -report server and report server tempDB and also restored the analysis databases from SQL 2012 server.
The issue I am now facing is while configuring SSRS reports and giving a connection string as below :
Provider=SQLNCLI11.1;Data Source=xx;Integrated Security=SSPI;Initial Catalog=xx
I am selecting option : Credentials stored securely in the report server, and then entering user name and password.
See screen shot below:
Once I enter them and then click on test connection an error comes like this:
Either the user, NDOMAIN\SVCACC, does not have access to the XXMart database, or the database does not exist. (rsAdomdDataProviderError)
I checked permissions of NDOMAIN\SVCACC under security of both Analysis services and the XXMart database and permissions are good and the login is mapped correctly.
Does any of you have a clue of what this can be?