Post reply

Connect to an Analysis Services cube from SSMS

  • April 20, 2016 at 5:04 am

    #310047

    Hi,

    I'm trying to connect to an analysis services cube that's on a different domain to the one I'm on.

    When I connect with SSMS it's using my local domain hence access is not possible.

    Is there anyway I can specify the correct domain for Windows Authentication?

    Best

    Lee

  • April 20, 2016 at 5:30 am

    #1873269

    Hi,

    is it possible to start the SSMS with the credentials from the different domain on your local workstation?

    "runas /netonly /user:differentDomain\USERNAME "C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\ManagementStudio\Ssms.exe""

    Kind regards,

    Andreas

  • April 20, 2016 at 5:51 am

    #1873275

    you can also do a shift + Right Click on the item to get a Run As Different User context,w here you can put in the other domain credentials.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • April 20, 2016 at 7:09 am

    #1873312

    Neither of these things worked. When I try running as a different user I get a message : The security database on the server doesn't have a computer account for this workstation trust relationsdhip.

  • April 20, 2016 at 7:52 am

    #1873330

    I got it working in the end. I misinterpreted the /user as username.

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

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