• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 184
  • Last Modified:

Sql 2005 how can we differentiate between server and client


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.

2 Solutions
Jai STech ArchCommented:
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.,
bsharathAuthor Commented:

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
Assuming the underlying programs are present, that would be a server.
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Jai STech ArchCommented:
go to
Control Panel --> Administrative Tools - Services

And check SQL Server if something exists tyhere then you have server else you have a client...
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

Jai STech ArchCommented:
@dportas --> what do you think is the diffrerence between what I said and what you said ?
bsharathAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now