Post reply

Connection to AS via SSMS

  • April 15, 2016 at 5:26 pm

    #150487

    I got a request from someone today and need some assistance. They need to connect to an SSAS instance in someone's domain. They only have SSMS loaded on their machine. There is no Analysis Services option on the server type drop-down at the login screen. What do I need to have for him to be able to do this?

  • April 16, 2016 at 4:14 am

    #1872554

    mcopa (4/15/2016)

    I got a request from someone today and need some assistance. They need to connect to an SSAS instance in someone's domain. They only have SSMS loaded on their machine. There is no Analysis Services option on the server type drop-down at the login screen. What do I need to have for him to be able to do this?

    It sounds as if they have SSMS Express which will not allow connections to SSAS. Luckily, full SSMS is now free as part of SQL Server 2014 Developer Edition which can be downloaded from the Visual Studio Dev Essentials site. Only the management tools from this download need to be installed.

    I'm on LinkedIn

  • April 16, 2016 at 9:05 pm

    #1872577

    What PB_BI said.

    It's also worth noting that you can access SSAS via BIDS or SSDT (depending on the version of SSAS you ate running).

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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