Home / server / Questions / 176573
Accepted
codeulike
Asked: 2010-09-01 07:53:35 +0800 CST

SQL Server Management Studio licensing [duplicate]

  • 772

Possible Duplicate:
Can you help me with my software licensing question?

We have a SQL Server 2008 server, licensed per processor.

If I want to install SQL Server Management Studio (SSMS) on a couple of desktop PCs (in order to connect to the server), do I need more licenses?

I can't find much about this in the SQL licensing FAQs.

sql-server-2008 licensing

2 Answers

  1. Best Answer

    No. You can install as many instances of SSMS as you want (it doesn't require a license)...provided you have the CALs to access SQL server.

    Having said that, I am not a Microsoft Licensing Scheme(tm) expert...

    Edited to add:

    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.

    From here

    • 7

  2. There's no license requirement for the SQL Tools beyond having the needed CALs (or a CPU license for the servers) so that you can connect without issue.

    Now any computer which has the server components on it (SQL Engine, SSAS, SSRS, etc) will need to be fully licensed. So if you have one CPU license for one server running the database engine with 1 physical CPU and a second server with 1 physical CPU running SSAS then you need to buy another CPU license for the SSAS server.

    • 1