locked
Issue with remote connection to SSAS Tabular via non-domain PC RRS feed

  • Question

  • Hi

    Just a quick bit of background to help with this.  I am a consultant working with a client on some reporting development.  I have a VPN to their site and can successfully connect to their SQL servers to run queries in SSMS and Excel.  I have also built PowerPivot workbooks that connect to these servers.  I use SQL server authentication to connect as Windows authentication would not work, given that I am not an employee and not logged on to a domain account.

    We installed SSAS Tabular (successfully) in order to upload one of the power pivot data models onto a server environment.  The service is running on the server.  We can see the tabular object on SSMS and can see the services listed on SSCM.

    The issue arises when I use my laptop to try to connect to the Tabular object but my machine can't see it or connect to it on SSMS, Excel, Visual Studio.  Is this because Analysis Services DOES NOT have the equivalent of SQL server authentication?  As a data model developer, must I be logged into a domain machine as a domain user with admin rights to the tabular object?  Is there a way I can connect from my home & personal laptop?

    I would be very grateful for any help & advice you can offer

    Many Thanks in advance

    Stuart

    SSAS Tabular on SQL Server 2016; My Laptop: Windows 10 pro; SSMS 17.1 installed on server & my laptop; visual studio 2017 + AS/RS addons installed on my laptop; Let me know if you need more environment info

    Saturday, July 1, 2017 10:46 AM

Answers

  • It does not have SQL Authentication. Your options are windows authentication, Active Directory Password authentication, and Active Directory Universal Authentication.

    You will need to RDP into a desktop at your client site and then logon to the SSAS server from there using windows authentication.

    Saturday, July 1, 2017 11:27 AM

All replies

  • It does not have SQL Authentication. Your options are windows authentication, Active Directory Password authentication, and Active Directory Universal Authentication.

    You will need to RDP into a desktop at your client site and then logon to the SSAS server from there using windows authentication.

    Saturday, July 1, 2017 11:27 AM
  • You might be able to do this without having RDP to another machine. I have used a batch file using the windows "runas" command to run SSMS and SQL Profiler as a secondary account in the past. The command looks something like the following:

    runas /user:<domain>\<user> /netonly "%programfiles(x86)%\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Ssms.exe"

    I have not tried this with SSDT, but there is a good chance it will work. The /netonly switch only uses the credentials you specify for network connections, so you don't need to have your machine on the same domain.


    http://darren.gosbell.com - please mark correct answers

    Sunday, July 2, 2017 3:50 AM