Post reply

SSRS + SSAS Issue

  • August 6, 2021 at 4:23 pm

    #3917559

     

    Hi

    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?

     

    Thanks

     

  • August 7, 2021 at 5:10 pm

    #3917799

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • August 9, 2021 at 6:28 pm

    #3918223

    Make that user sysadmin, and see what happens.

    If it runs, then it's something with permissions,

     

    If it fails, then it's something with the configuration of SSRS/SSAS

     

    Michael L John
    If you assassinate a DBA, would you pull a trigger?
    To properly post on a forum:
    http://www.sqlservercentral.com/articles/61537/

  • August 11, 2021 at 10:06 am

    #3918697

    Thanks for response. I tried with SYS Admin access but same. Actually I restored the databases from SQL 2012 to a SQL 2014 server. Including report databases and the encryption key. the permissions are the same when compared on both old and new.

  • August 11, 2021 at 10:09 am

    #3918701

    Some details :

    I am configuring SCSM report on SQL SSRS server. For the multimart Data Source I selected Microsoft Analysis Services - as data source type and connection string given as below :

    <root><source id='DWDataMart' connectionString='Data Source=db;Initial Catalog=DWDataMart;Integrated Security=True' /><source id='OMDataMart' connectionString='Data Source=db;Initial Catalog=OMDWDataMart;Integrated Security=True' /><source id='CMDataMart' connectionString='Data Source=db;Initial Catalog=CMDWDataMart;Integrated Security=True' /></root>

     

    I am not sure if the above connection string is correct syntax ?

     

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply