Re: How can I get the Management Studio

Tibor,

I know there is no such a license SQL Server Tools license =)

As it says "any device that has SQL Server tools or technologies installed must have a valid license" in the Q & A, I end up with a question mark: "I have a SQL Server server which has SQL Server database engine and tools installed on it and have a license for that particular SQL Server server (processor or server + CAL whatever), however I want to use the SQL Server tool SSMS on another server in my environment, according to that Q & A, I'm using a SQL Server tool on another device other than that licensed SQL Server server and as it says 'you need a valid license for SQL Server tools' do I need any other SQL Server license for the other unlicensed server which I'd like to install only SSMS?"... This is the point I wonder.

Here's a "seperate" machine if this is the keyword. It's not going to be a SQL Server server; however, a SQL Server Tool is going to be used on it. According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it?

I think this Q & A could be clearer.

Here its link:
http://www.microsoft.com/sql/howtobuy/faq.mspx

--
Ekrem Önsoy



"Tibor Karaszi" <tibor_please.no.email_karaszi@xxxxxxxxxxxxxxxxxx> wrote in message news:25C21DFB-21A9-4363-87D8-E689C450B72D@xxxxxxxxxxxxxxxx
Ekrem,

I'd say that the key word here is "separate". There's no "SQL Server tools" license you can buy. I.e., if you are licensed to connect to the database instance, you are also licensed to use the tools. At least this is how I read it. :-)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> wrote in message news:%23D4hyfKwIHA.4560@xxxxxxxxxxxxxxxxxxxxxxx
I just want to share something weird with you guys on SQL Server Tools' licensing.

Here' s Q & A about licensing of SQL Server Tools:
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.

Even though it says a separate license is not required to run the SQL Server tools, in the second sentence it says any device that has SQL Server tools (SSMS is one of them) will need a SQL Server license. Isn't this a contradiction? Or do I get it wrong somehow?

--
Ekrem Önsoy



"Russell Fields" <russellfields@xxxxxxxxxx> wrote in message news:OE1d0G3vIHA.2188@xxxxxxxxxxxxxxxxxxxxxxx
Clara,

It looks like you may not have selected the "Workstation components, Books Online and Development Tools" when you installed SQL Server. If that is the case, just follow the instructions at http://support.microsoft.com/kb/913967

Of course, on a desktop you can install those tools, which include Management Studio, without installing the SQL Server engine.

RLF

"clara" <clara@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:9EEA3E9B-8A08-4451-8E66-BFA8BD662FB2@xxxxxxxxxxxxxxxx
Hi all,

I don't know why there is no Management Studio after I install SQL Server
2005 Developer Edition. Is something wrong during the installation? If not,
where can I get the Management Studio?

Clara
--
thank you so much for your help





.

Relevant Pages

  • Re: sql server express on same workstation as ssl 2005
    ... you mention that you have Visual Studio 2005 Professional Edition. ... Professional Edition license also includes a copy of SQL Server 2005 ... when you install SQL 2005 Express Edition you ...
    (microsoft.public.sqlserver.setup)
  • Re: How can I get the Management Studio
    ... I'd say that the key word here is "separate". ... There's no "SQL Server tools" license you can buy. ...
    (microsoft.public.sqlserver.tools)
  • Re: How can I get the Management Studio
    ... a SQL Server server; however, a SQL Server Tool is going to be used on it. ... According to this Q & A, I'll need another SQL Server license because I'll be using a SQL Server Tool on it? ... "any device that has SQL Server tools or technologies installed must have a valid license" ... It would basically mean we can buy one per processor SQL Server and install SSMS on all the machines in the world? ...
    (microsoft.public.sqlserver.tools)
  • Re: Are multiple-instances on a single cluster supported with SQL Server 2005 Standard Edition?
    ... If you have a per-proc license, you can run as many instances as your system ... can hold on the cluster. ... Personally, I would go with Standard Edition for a two-node, four-proc SQL ... Microsoft SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: SQL server 2005 license question
    ... If there is only one Physical CPU then it's enough buying only one Processor License for your SQL Server. ... you don't need to install the License. ...
    (microsoft.public.sqlserver.setup)