Installed SQL is Client or Server?

Question

Installed SQL is Client or Server?

C.K.Shaiju

SSCarpal Tunnel

Points: 4228
More actions
July 15, 2011 at 5:03 am

#389984

How do we find out the installed SQL is Client or Server?
_____________________________________________
One ounce of practice is more important than tonnes of dreams

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

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

Lowell SSC Guru Points: 323518 More actions · Answer 1

not sure what you mean.... the machine with the MSSQLSERVER service is the server...but "client" software can be installed on the server or on other machines...

what , for you, do you see is the difference between client and server in this case?

for me, client is a machine calling another machine for services of some type, whether SQL, Email, Websites, whatever.

the provider of the service is the server.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 2

Lowell,

Here I have 15 systems which have been already installed with SQL Server. But now I have to find out which all systems are installed as CLIENT and which all are installed as SERVERS. Because here I want only one SERVER and rest all should be CLIENT. If there are more than one SERVER, I need to uninstall that excess SERVERS and install CLIENT on that box.

_____________________________________________
One ounce of practice is more important than tonnes of dreams

Ant-Green SSC Guru Points: 113507 More actions · Answer 3

you will need to look at the services on all of the machines you want to check

if the machine has a service which has MSSQLSERVER or MSSQL:#### where #### is the instance name then it has the server components installed

Lowell SSC Guru Points: 323518 More actions · Answer 4

C.K.Shaiju (7/15/2011)
Lowell,
Here I have 15 systems which have been already installed with SQL Server. But now I have to find out which all systems are installed as CLIENT and which all are installed as SERVERS. Because here I want only one SERVER and rest all should be CLIENT. If there are more than one SERVER, I need to uninstall that excess SERVERS and install CLIENT on that box.

you could use something like SQL Ping or SQL Recon to discover all SQL Server services on the network.

from there you could decide which ones are valid, and uninstall SQL from those machines...is that what you mean?

by client, i'd have to assume you are asking which machines have SQL Server Manangement Studio installed, but not the SQL Server Service?

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 5

Just to add to what was already said you can go into add/remove programs and looking for Microsoft SQL Server 2008 (Server) and several other options.

But if you see the Native Client and books online without the Server Microsoft SQL Server 2008 installed program. Then you only have the client.

I'm sure that there are easier ways to identify this. If you do not have local Host registered or are unable to register your local machine then you do not have the Server installed.

You can also check for registry entries to verify the installation.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 6

Welsh Corgi (7/15/2011)I'm sure that there are easier ways to identify this. If you do not have local Host registered or are unable to register your local machine then you do not have the Server installed.

Yes, There should be some easier way. I am searching for something like below.

SELECT

SERVERPROPERTY('MachineName') as Host,

SERVERPROPERTY('InstanceName') as Instance,

SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/

SERVERPROPERTY('ProductLevel') as ProductLevel, /* RTM or SP1 etc*/

Case SERVERPROPERTY('IsClustered') when 1 then 'CLUSTERED' else

'STANDALONE' end as ServerType,

@@VERSION as VersionNumber

_____________________________________________
One ounce of practice is more important than tonnes of dreams

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 7

C.K.Shaiju (7/15/2011)

Yes, There should be some easier way. I am searching for something like below.
SELECT
SERVERPROPERTY('MachineName') as Host,
SERVERPROPERTY('InstanceName') as Instance,
SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/
SERVERPROPERTY('ProductLevel') as ProductLevel, /* RTM or SP1 etc*/
Case SERVERPROPERTY('IsClustered') when 1 then 'CLUSTERED' else
'STANDALONE' end as ServerType,
@@VERSION as VersionNumber

Good deal, that sounds nice and easy. Go for it. 🙂

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

sagar dhanawade SSC Enthusiast Points: 105 More actions · Answer 8

igot you as same question i faces some time back.. U can check it through services.msc command through Run. you will find there all services running on your machine there if you find the MSSQLSEVER/EXPRESS or something like that then its confirmed that there is server installed on your machine.

Orlando Colamatteo SSC Guru Points: 182279 More actions · Answer 9

C.K.Shaiju (7/15/2011)
Welsh Corgi (7/15/2011)I'm sure that there are easier ways to identify this. If you do not have local Host registered or are unable to register your local machine then you do not have the Server installed.
Yes, There should be some easier way. I am searching for something like below.
SELECT
SERVERPROPERTY('MachineName') as Host,
SERVERPROPERTY('InstanceName') as Instance,
SERVERPROPERTY('Edition') as Edition, /*shows 32 bit or 64 bit*/
SERVERPROPERTY('ProductLevel') as ProductLevel, /* RTM or SP1 etc*/
Case SERVERPROPERTY('IsClustered') when 1 then 'CLUSTERED' else
'STANDALONE' end as ServerType,
@@VERSION as VersionNumber

The above SQL must execute against an instance...i.e. you can only run this against the "servers" [sic].

Lowell pointed you towards a good solution. Use SQL Ping or one of the other discovery tools on the market.

There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato

Welsh Corgi SSC Guru Points: 116520 More actions · Answer 10

sagar dhanawade (7/15/2011)
igot you as same question i faces some time back.. U can check it through services.msc command through Run. you will find there all services running on your machine there if you find the MSSQLSEVER/EXPRESS or something like that then its confirmed that there is server installed on your machine.

I also prefer Lowell's solution.

I know that this is off subject but I have not seen too many instances of SQL Server Express running on a Server. The norm would to see an Express running on a Developer's Client.

My Personal preference would be to cough up the change and purchase the Developer Edition.

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 11

Thanks to you all for your solutions.

Welsh Corgi (7/15/2011)
Good deal, that sounds nice and easy. Go for it. 🙂

🙂 Welsh/OPC, I was just giving an example. 🙂 and looking for something simple like this.

Lowell (7/15/2011)
you could use something like SQL Ping or SQL Recon to discover all SQL Server services on the network.
from there you could decide which ones are valid, and uninstall SQL from those machines...is that what you mean?
by client, i'd have to assume you are asking which machines have SQL Server Manangement Studio installed, but not the SQL Server Service?

Yes Lowell. But I am not able to install 3rd party tools in my system as it is required approvals and it is a long process. But if no other simple way, I need to try this.

Anthony/Sagar, I shall try this also.

_____________________________________________
One ounce of practice is more important than tonnes of dreams

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 12

Hi All,

I have attached services list of 2 different systems. Would you please check and help me to confirm which one is SQL Server and which one is SQL Client. I am totally confused, because most of the services showing the same as service_1.jpg.

_____________________________________________
One ounce of practice is more important than tonnes of dreams

Lowell SSC Guru Points: 323518 More actions · Answer 13

that's easy...they are ALL server versions.

if it is installed as a service, it is the server version. always, no exceptions.

the client tools don't show up as a service

If you go to Add/Remove Programs, when you find SQL Server, you should be able to change the installations and uninstall everything except the client tools.

As an aside, SQLRecon does not require installation at all. It is a stand alone /NET executable that you can run. Other's can tell you if SQLPing is the same.

Plus you only need to run it ONCE, from YOUR machine, and not on "each machine" or anything like that. is searches teh network with your credentials.

If it's the right tool for the job, then you need to go to the effort of getting permission to use it. A lot of peers here felt the same way, that a tool is the best solution, so take their advice into consideration as well.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

C.K.Shaiju SSCarpal Tunnel Points: 4228 More actions · Answer 14

Hi Lowell,

Thanks a lot.

Now only I got an Idea about the installation. Thanks.

_____________________________________________
One ounce of practice is more important than tonnes of dreams