Sql 2005 how can we differentiate between server and client

Posted on 2007-10-17
Last Modified: 2010-03-19

Sql 2005 how can we differentiate between server and client.

I have a DVD in which i have 2 folders
2. Tools

How can we differentiate them by looking at the setup and by looking at the installed components in Add/Remove programs.

Question by:bsharath
    LVL 14

    Expert Comment

    if you install only the TOOLS / COMPONENTS then it is a can use the Manangement studio to connect to the server...
    if you are installing a SERVER then it will be asking for the instance name / server user name and password...authentication modes...etc.,
    LVL 11

    Author Comment


    I have these in the start menu

    Analysis Services
    Configuration Tools
    Database Engine Tuning Advisor.lnk
    Notification Services Command Prompt.lnk
    Performance Tools
    Reporting Services Configuration.lnk
    SQL Server Configuration Manager.lnk
    SQL Server Error and Usage Reporting.lnk
    SQL Server Management Studio.lnk
    SQL Server Profiler.lnk
    SQL Server Surface Area Configuration.lnk

    Is this a server or Client
    LVL 42

    Assisted Solution

    Assuming the underlying programs are present, that would be a server.
    LVL 14

    Accepted Solution

    go to
    Control Panel --> Administrative Tools - Services

    And check SQL Server if something exists tyhere then you have server else you have a client...
    LVL 22

    Expert Comment

    The client tools could be installed on both client and server so looking at Start Menu won't help you.

    In Explorer:
    right-click My Computer
    Click Manage
    Select "Services and Applications" > "Services"
    If you can see the "SQL Server (MSSQLSERVER)" service listed then you have the server component installed

    LVL 14

    Expert Comment

    @dportas --> what do you think is the diffrerence between what I said and what you said ?
    LVL 11

    Author Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now