Post reply

install SQL server client managment studio, but also see integaration service as a shared feature

  • November 17, 2011 at 11:32 am

    #390894

    I often need to install SQL management studio for people that need to query a production database.

    I know if we have a processor licensed SQL server, then the use of management studio for client computer is free in license aspect, so what I do for installation is using the installation media >> setup.exe, when choose features to install, I only chose the shared features and check all the items under it, that include SQL management studio, Business management studio, integration service, bookonline , client connectivity etc.

    My question is can I install all these shared features for my clients. And we don't need to buy license for the client tools including all above as long as we have a processor based server license?

    Thanks

  • November 18, 2011 at 2:42 am

    #1409747

    currently trying to find a licensing document where I believe that SQL, AS, RS, IS are the licensed parts of SQL, so you cannot install SSIS on client machines unless you use the developer media or MSDN media, otherwise you need to licence the client machines

    once I find the document I will upload it

    edit

    document found, page 6

  • November 18, 2011 at 9:46 am

    #1410034

    Thanks a lot.

    I have noticed that before but thought that is for server only.

    In our enviorment we often have people to request to install SQL server client tools on their computer.

    For developers, we have some limited developer edition license to install for them. But for some other people, they only want to query the database, not doing developement, we only want to install Sql server management studio for them, as I understand, if the server has processor license, the client tools are free of license.

    But I just don't understand what exactly is client tools.

    Are those in shared features all client tools?

    So when people request to install SQL management studio on their workstation PC, what exactly I can install without needing an additional license, what can I check to install at the shared features screen, I have attached the shared feature installation screenshot in the attachment.

    Also can I install business intelligence studio that in shared features without additional license?

    All these are based on the condition our server has already installed a processor unlimited connection license.

    Can anyone make this clear?

    Thank you in advance.

  • November 18, 2011 at 10:24 am

    #1410057

    You cannot install integration services without a separate license.

  • November 18, 2011 at 10:25 am

    #1410059

    How about business intelligence development managment studio?

    And also how about other items in the shared features in my previous post?

  • November 18, 2011 at 10:51 am

    #1410079

    you can install all of shared features except ssis without needing a licence

    for client tools all you need to install is management tools and if you want to use ssms2008 on 2005 or 2000 then the backwards compatability

  • November 18, 2011 at 10:56 am

    #1410082

    anthony.green (11/18/2011)

    you can install all of shared features except ssis without needing a licence

    SSIS do you mean both intergration service? How about BIDs?

    [for client tools all you need to install is management tools and if you want to use ssms2008 on 2005 or 2000 then the backwards compatability

    Thanks, I guess I will install all those I can without needing additional licenses once include books on line etc.

  • November 18, 2011 at 11:11 am

    #1410089

    you can install bids just not ssis, only install bids if they need it the less someone has the less damage they can do

  • November 18, 2011 at 11:15 am

    #1410091

    Thanks, if BIDS installed, they develop some ssis package, it cannot be run if I havenot installed ssis service on the computer, correct?

    And if integration service is listed here in shared features, it should be shared,

    I guess I just not sure what shared features mean?

    Thanks

  • November 21, 2011 at 6:57 am

    #1410683

    you can run packages in BIDS without SSIS being installed, which is why I always go on, if they dont need BIDS they dont get BIDS

    shared features is parts of the installation which is shared across all instances

    you can only have one installation of SSIS on the server and only one copy of SSMS

    where as depending on what you run (STD/ENT) you can have upto 50 instances of the engine, as or rs which is not a shared feature as you can run multiple

  • November 21, 2011 at 11:54 am

    #1410974

    anthony.green (11/21/2011)

    you can run packages in BIDS without SSIS being installed,

    I'm interested in this, without ssis , I can still run packages in BIDS?

    So the package not using ssis service?

  • November 21, 2011 at 12:46 pm

    #1411014

    No it isn't it uses something else. And truth be told the SSIS service doesn't really do all that much, it is just a little more than a service interface to DTExec. But its licensing is with the server, so if you install it you have to have a server license. The tools require a licensed server, somewhere.

    A poster futher up said there can only be one SSMS, that is partially true, I have had installed at one time SSMS for SQL 2005 and SQL 2008, there are rare occasions when you cannot use SSMS 2008 for 2005, the most notable is SSIS 2005. But yo ucan only have one SSMS per version.

    CEWII

  • November 21, 2011 at 2:33 pm

    #1411052

    Thanks, good to know

  • November 22, 2011 at 1:53 am

    #1411258

    Sorry Elliot I should have been a bit more clear on the SSMS part, yes you can only install one copy of SSMS of each version on a machine

    E.g. you dont have 50 SSMS 2008 client installs just because you have 50 SQL Engine instances on a machine, hence its a shared feature across all of the instances.

    There are some cases where you need to have the other tools as well, especially when controling SSIS packages in SQL2005 as SSMS2008 wont do this.

  • November 22, 2011 at 9:00 am

    #1411614

    No problem, it could have been the way I read it as well.

    Simplest answer 1 SSMS per SQL Version Installed regardless of the number of instances.

    CEWII

Viewing 15 posts - 1 through 14 (of 14 total)

You must be logged in to reply to this topic. Login to reply