Solved

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

Posted on 2011-03-21
4
1,075 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

739 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