Post reply

security ? for SSAS tabular

  • December 31, 2018 at 12:06 pm

    #409405

    have a ssas 2014 security ? vendor wanted connections to one of our sql servers and SSAS tabular instance. They say they can only use sql authentication but it looks like for SSAS tabular instance you can only use windows authentication, anyone have a way around that?

  • December 31, 2018 at 12:33 pm

    #2017674

    they need to bump up their skillset, and this is your opportunity to help them.
    do not allow SQL connections. period. eventually that password gets passed around and is insecure.

    SSAS only supports windows authentication, whether Tabular or OLAP.

    create an AD account for them, ie yourdomain\SpecificVendorUser
    they must be getting in via VPN already to get into your network, so make them learn how to shift+right click on an SSMS shortcut, and chose "run as a different user"
    then they can launch as that yourdomain\SpecificVendorUser with the correct windows password. they can do the same with Visual Studio, if they are connecting to deploy or download the packages.

    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!

  • December 31, 2018 at 12:43 pm

    #2017675

    that is what I concluded dealing with vendor the day before a holiday not always the best time for answers

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

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