Solved

Does the SQL Server 2008 Runtime license allow you to install the Management Studio as well?

Posted on 2011-03-21
4
1,069 Views
Last Modified: 2012-05-11
Folks -

I have an application that a vendor will be installing in the coming weeks that includes a SQL Server 2008 Runtime license.  Microsoft describes this license as the "complete SQL code embedded within the vendor's application".  I'm assuming by embedded, they merely mean the bits are bundled with the vendor's code, not that it's compiled in or linked in any way.  If I'm wrong on that please let me know.

My big question is this... after they install it, does the "Runtime" license afford me the luxury of installing the SQL Management Studio on the same box?  Or must I manage the instance remotely?

Microsoft is pretty clear that there are no technical differences between the "Runtime" version versus "Standard" / full license SQL editions, however, they are not clear about whether or not the Management tools can be installed.

Any input is appreciated.
0
Comment
Question by:amendala
  • 2
4 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
ID: 35184456
You can always install SSMS 2008 R2 Express which will manage any version of SQL Server up to R2.  It is free to download and install.
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 250 total points
ID: 35184484
The Runtime License makes you a distributor, as mentioned here

http://support.microsoft.com/kb/917400

There is a Runtime License for Standard Edition, Runtime License for Enterprise Edition etc.  All it means is that you are distributing SQL Server for use with your app exclusively.  The recipient cannot put other databases on, nor connect to the data/server for other purposes (e.g. reporting) - only your app can utilize the SQL Server installed, whatever the edition.

It follows that Profiler etc tools within the edition are also installable.
0
 
LVL 24

Assisted Solution

by:DBAduck - Ben Miller
DBAduck - Ben Miller earned 250 total points
ID: 35195894
Management Studio is licensed with the Workgroup, Standard and Enterprise editions.

You can install Management Studio Express and manage it, but the Management Studio is part of the license of SQL cannot be installed just because you have a runtime license for the application.
0
 

Author Closing Comment

by:amendala
ID: 35343707
My Microsoft licensing representative has confirmed for me that you can use the full blown SQL Management Studio to manage a runtime instance.  If the customer desires, they can install the Management Studio code on the same machine as the application using the runtime instance for management.

The runtime license is more about distribution restrictions than functionality.  All the core SQL functionality with a few exceptions exists in the runtime as well as the "full" versions.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now