Post reply

Query Analyzer - Licensing

  • December 11, 2003 at 4:13 pm

    #76094

    Hello All.

    Does anyone know if you need a seperate license to install/use Query Analyzer?

    We have several power-users at our organisation who would benefit from using QA, but I am reluctant to install the SQL Server Client Tools on their pcs without finding out about licensing requirements.

    Cheers,

    Kevin


    Cheers,

    Kevin

  • December 11, 2003 at 4:33 pm

    #485861

    Client tools are licensed with the Server. They are useless without a Server installed somewhere. You can install as many copies as needed.

    Make sure you do a custom install and only put on QA. Wouldn't want your "power-users" playing around with EM

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • December 11, 2003 at 5:34 pm

    #485865

    I think you can install QA, but your access to the server requires a CAL.

    Steve Jones

    sjones@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/sjones

    The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/

    http://www.dkranch.net

  • December 11, 2003 at 9:45 pm

    #485873

    If the Server software was bought on a "per CPU" basis, CALs don't enter the picture.

    Isn't that right ??



    Arden

  • December 12, 2003 at 4:37 am

    #485910

    Weissa, that's my understanding as well.

  • December 12, 2003 at 8:19 am

    #485957

    As I understand it, the software is free you can install it everywhere. BUT you need a license to access the server, either a CAL or a per CPU licensed server.

    KlK, MCSE


    KlK

  • December 12, 2003 at 10:19 am

    #485991

    You can also connect to SQL through ODBC and Access. The query interface is easy to work with.

    -Isaiah


    -Isaiah

  • December 12, 2003 at 6:59 pm

    #486054

    If you connect with ODBC and Access, or write your own program, it doesn't matter -- you still need the CAL or need to license SQL on a per-processor basis.

    It's not the software you are licensing, it is the right to connect to SQL Server.

  • December 13, 2003 at 10:47 am

    #486061

    Unlike SQL Server 7, SQL 2000 does not offer per-server licensing.

    SQL Server (2000) has 3 licensing modes.

    - Per Processor: Any number of clients/devices can connect WITHOUT the need for each client to have a CAL. Each CPU on the server would need to be licensed.

    - Server plus device CAL - Requires a server license plus a license for each device connecting to the server. Here any user can access a server from a device as long as that device has a CAL.

    - Server plus user CAL - Requires a server license plus a license for each user connecting to the server. Here a user can access the server from any device as long as the user has a CAL.

    To answer your question, it would depend on the licensing mode you've installed the server with.

    - Per Processor: You're good to go

    - Server plus device CAL - the device / machine that your users're connecting from would need a CAL. You could install the client tools on a few machines, and have the users share them, though I'm not sure of the feasibility of this option for you 🙂

    - Server plus user CAL - each user would need a CAL, which would travel with them if they moved between machines/devices.

    Hope this helps clarify more than confuse 🙂

    RS


    RS

Viewing 9 posts - 1 through 8 (of 8 total)

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