July 1, 2017 at 4:56 am
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
July 1, 2017 at 5:07 am
Analysis server allows windows connections only, you are correct.
i those situations, we've added consultants to have a domain name on our network, and they connect via citrix to establish the credentials.
you could try adding your machine name\username as a user, ie on the domain BigBang, where bigbang\bidevelopers and bigbang\lowell are already added, you could try adding laptopname\stuartbisset.
Lowell
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply