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.

marked as duplicate by Skyhawk, Mark Henderson Nov 14 '11 at 5:18

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

  • Although this was closed as a duplicate, the "cannonical question" didn't give specifics about SQL Server licensing and did not include direct me to anything useful. This "duplicate question" on the other hand had exactly the information I needed. – Registered User Oct 12 '12 at 20:44

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

  • And with processor licensing CALs are not an issue, presumably? – codeulike Aug 31 '10 at 16:12
  • 1
    If you can find a source for 'SSMS doesn't require a license' that would be handy, too. – codeulike Aug 31 '10 at 16:15
  • Edited my answer above. – GregD Aug 31 '10 at 16:27
  • And to answer your question about the "processor" license. That particular license covers all devices that access THAT processor. – GregD Aug 31 '10 at 16:37
  • Thanks for the edit, but that bit of the Licensing FAQ is about as clear as mud to me. 'Any device that has SQL server tools ... must have a valid SQL Server license'. I think you are saying we should interpret that as "CAL is sufficient"? – codeulike Aug 31 '10 at 16:51

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.

Not the answer you're looking for? Browse other questions tagged or ask your own question.