SQL server license

  • I have a couple of questions about the SQL server licensing.

    I see on microsoft site FAQ:

    1.

    Q. Do I need a separate license to run the SQL Server tools and analysis services?

    A. No, a separate license is not required. However, any device that has SQL Server tools or technologies installed must have a valid SQL Server license.

    My question of above is can we install a client tool for example SSMS on a client computer does it need license, also not sure if we install analysis service on another computer,does it need a license?

    2. We usually install SQL server database engine and SSIS service on a server, then install Reporting service on another server.

    So does the reporting service on the other machine need a license?

    Thanks

  • sqlfriends (5/27/2011)


    I have a couple of questions about the SQL server licensing.

    I see on microsoft site FAQ:

    1.

    Q. Do I need a separate license to run the SQL Server tools and analysis services?

    A. No, a separate license is not required. However, any device that has SQL Server tools or technologies installed must have a valid SQL Server license.

    My question of above is can we install a client tool for example SSMS on a client computer does it need license, also not sure if we install analysis service on another computer,does it need a license?

    2. We usually install SQL server database engine and SSIS service on a server, then install Reporting service on another server.

    So does the reporting service on the other machine need a license?

    Thanks

    1. For the tools, you don't need a new license, for things like the analysis services SERVER you would very likely another license.

    2. They are covered under a single license IF they are installed on the same box, but if you install a part of the server components (DB Engine, SSRS, SSIS, or SSAS) on another box they are not covered under that same license.

    CEWII

  • The articles listed below may provide you some insight.

    http://msmvps.com/blogs/anguslogan/archive/2004/10/03/14788.aspx

    http://www.microsoft.com/Sqlserver/2005/en/us/special-considerations.aspx

    Elliot answered you question directly.

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

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

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