Windows Eval+SQL developer for external OLAP access for students to play with DAX

Alessandro Tiberti Bertin 1 Reputation point
2022-01-22T09:54:25.913+00:00

Hi,

scenario : training on DAX. Windows SRV eval + SQL Developer

External (autheneticated and connecting from internet) users with SSAS read-only access to connect with DAX Studio (and Power BI Desktop) to SQL developer's OLAP cube so they can create custom measures in DAX.

Can this be done with the free licenses mentioned above?

If not, would you be able to explain why and by consequence which licenses you esteem would be required?

Thanks!

Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,084 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,243 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CarrinWu-MSFT 6,851 Reputation points
    2022-01-24T02:06:18.73+00:00

    Hi @Alessandro Tiberti Bertin ,

    Welcome to Microsoft Q&A!

    SQL Server Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment. Both Power BI and DAX Studio are free tools.

    For Windows Server, which version do you want to choose?

    For more License issue, we suggest that you could consult professionals. Please call 1-800-426-9400, Monday to Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to directly speak to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information. Or you could get help from Volume Licensing Service Center support.

    Best regards,
    Carrin

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments
  2. Limitless Technology 39,341 Reputation points
    2022-01-24T15:20:10.79+00:00

    Hello AlessandroTibertiBertin

    There is no reason why the SQL Developer should have any limitation for the operations you are trying to accomplish.

    If anything, you can check the limitations of Windows Server evaluations:

    https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-r2-and-2012/jj574204(v=ws.11)#limits-of-evaluation-versions

    If you are interested in more details about licenses, I would recommend contacting a Microsoft Partner or reseller that can give accurate information based on you location:
    https://appsource.microsoft.com/en-us/marketplace/partner-dir

    --------------------------------------------------------------------------------------------------------------------------------------

    --If the reply is helpful, please Upvote and Accept as answer--

    0 comments