[Last Call] Learn how to a build a cloud-first strategyRegister Now


Sql 2005 how can we differentiate between server and client

Posted on 2007-10-17
Medium Priority
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

by:Jai S
ID: 20098722
if you install only the TOOLS / COMPONENTS then it is a CLIENT...you 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

ID: 20098782

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

dqmq earned 400 total points
ID: 20098893
Assuming the underlying programs are present, that would be a server.
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

LVL 14

Accepted Solution

Jai S earned 1600 total points
ID: 20098896
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

ID: 20098901
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

by:Jai S
ID: 20098905
@dportas --> what do you think is the diffrerence between what I said and what you said ?
LVL 11

Author Comment

ID: 20098926

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

831 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