Post reply

SSAS remote connectivity issue

  • October 30, 2019 at 9:33 am

    #3693005

    Hi ,

    I installed SQL 2017 Deloper edition in my server. Installed with ABCDomian\Administrator.

    I am able to connect SSAS with windows credentials.

    Requirement is one user wants to connect SSAS remotely from his SQL management studio..He signin his PC with ABCDomain\xyz username. using his windows authentication not able to connect ssis.

    I noticed there is no sql server authentication to connect ssas. Only windows credentails we can connect ssas? If some user from same domain wants to connect remotely then how?

    How to conenct ssas using his account ABCDomain\xyz? Please help.

    Thanks,

    Jo

    • This topic was modified 5 years ago by  pols.

  • October 30, 2019 at 2:02 pm

    #3693120

    This could be a number of things.  I would check:

    1. Is the user listed as a user in the database they are trying to access?
    2. Can you connect to the database from any other machine?

    If the error comes quickly, it is more likely to be the first item.  If the error takes 20 - 30 seconds after the login attempt to come up, then you are likely looking for a firewall issue, or other network connectivity or name resolution problem.Is the user listed

Viewing 2 posts - 1 through 1 (of 1 total)

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