September 21, 2009 at 6:16 am
Hello All,
How can we find the installation type of SQl on machine
mens is client or server is isntalled on the server .
-Narendra
September 21, 2009 at 6:25 am
Narendra-587652 (9/21/2009)
Hello All,How can we find the installation type of SQl on machine
mens is client or server is isntalled on the server .
-Narendra
Hi Narendra
Start bychecking your version
use:
SELECT @@VERSION
or use:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')
to see your installed edition.
@@version should return the desired results
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:40 am
Hi
thank's for reply
can i know about (Client or Server) of a machine by seeing 'Add or Remove Programs'
September 21, 2009 at 6:42 am
Narendra-587652 (9/21/2009)
Hithank's for reply
can i know about (Client or Server) of a machine by seeing 'Add or Remove Programs'
If you chose "Client Tools Only" in the setup process, given you are running a 2000 instance, yes.
Else try running setup again, and see what functionality is installed already - should be clear from that.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 6:52 am
thank's for prompt response
i have 500 server and differnt version of SQl(2000,2005,2008) and have to
find SQL client or SQL server installed on these server .
Can you pls help to to find the best way to do it
September 21, 2009 at 7:01 am
Narendra-587652 (9/21/2009)
thank's for prompt responsei have 500 server and differnt version of SQl(2000,2005,2008) and have to
find SQL client or SQL server installed on these server .
Can you pls help to to find the best way to do it
Ok, now we getting somewhere, thank you for the info...
I believe the following may help you:
run this from your command prompt:
C:\>osql -L
for an added text list, use:
C:\>osql -L >> c:\mysqlserverlist.txt
voila, your sql servers lised.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 7:11 am
Henrico Bekker (9/21/2009)
Narendra-587652 (9/21/2009)
thank's for prompt responsei have 500 server and differnt version of SQl(2000,2005,2008) and have to
find SQL client or SQL server installed on these server .
Can you pls help to to find the best way to do it
Ok, now we getting somewhere, thank you for the info...
I believe the following may help you:
run this from your command prompt:
C:\>osql -L
for an added text list, use:
C:\>osql -L >> c:\mysqlserverlist.txt
voila, your sql servers lised.
Unless I am mistaken, osql returns 2 copies of the same server for tcp and named pipes.
use SQLCMD -L > Servers.txt
to output the results into a text file you can look at.
and I was under the impression that it only returned servers that are using the default port.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 21, 2009 at 7:15 am
good , but it will not help for findinding client
can we find some other alternative way as its not geting for all server
September 21, 2009 at 7:15 am
Silverfox (9/21/2009)
Henrico Bekker (9/21/2009)
Narendra-587652 (9/21/2009)
thank's for prompt responsei have 500 server and differnt version of SQl(2000,2005,2008) and have to
find SQL client or SQL server installed on these server .
Can you pls help to to find the best way to do it
Ok, now we getting somewhere, thank you for the info...
I believe the following may help you:
run this from your command prompt:
C:\>osql -L
for an added text list, use:
C:\>osql -L >> c:\mysqlserverlist.txt
voila, your sql servers lised.
Unless I am mistaken, osql returns 2 copies of the same server for tcp and named pipes.
use SQLCMD -L > Servers.txt
to output the results into a text file you can look at.
and I was under the impression that it only returned servers that are using the default port.
Silverfox, it could be? but mine only returned distinct values, on for ech server with SQL installed, but where 2000 and 2005 was running it liste each.
I received accurate results with osql -L.
I guess Narendra can try both and see which results is suitable.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
September 21, 2009 at 7:21 am
What has been suggested will work for finding server installation, within the same domain. however finding out client installations, if you mean workstation components cannot be done that easily.
If you need to know who has installed the client tools, but not the server product. You would have to be speak to who manages the recording of software installations.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 21, 2009 at 7:21 am
C:\>osql -L listens TCP/IP and Named Pipes, that is why you may get duplicates in the server list.
Of course when the one of them is disabled you will not get any duplicates..
September 21, 2009 at 7:22 am
Sergey Vavinskiy (9/21/2009)
C:\>osql -L listens TCP/IP and Named Pipes, that is why you may get duplicates in the server list.Of course when the one of them is disabled you will not get any duplicates..
I did mention that, in my post 😛
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 21, 2009 at 7:24 am
Correct, you did it.:-)
It was my answer to
Silverfox, it could be? but mine only returned distinct values, on for ech server with SQL installed, but where 2000 and 2005 was running it liste each.
I received accurate results with osql -L.
September 22, 2009 at 1:40 am
thank's to all for your valuable suggestion.
but still the problem is same .
as it due to domain access it not solving my problem .
is three any way by seeing the add remove programme we can say server or client is installed on this server.
Pls give your suggestion
September 22, 2009 at 2:21 am
Narendra-587652 (9/22/2009)
thank's to all for your valuable suggestion.but still the problem is same .
as it due to domain access it not solving my problem .
is three any way by seeing the add remove programme we can say server or client is installed on this server.
Pls give your suggestion
Go to your services (services.msc) on each server and see if there is a service running for your sqlserver. If not its a client installation. Otherwise its a server. Is this what you are looking for?
---------------------------------------------------------------------------------
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply