how to knw clint or server

  • Hello All,

    How can we find the installation type of SQl on machine

    mens is client or server is isntalled on the server .

    -Narendra

  • 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

  • Hi

    thank's for reply

    can i know about (Client or Server) of a machine by seeing 'Add or Remove Programs'

  • Narendra-587652 (9/21/2009)


    Hi

    thank'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

  • 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

  • Narendra-587652 (9/21/2009)


    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

    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

  • Henrico Bekker (9/21/2009)


    Narendra-587652 (9/21/2009)


    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

    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]

  • good , but it will not help for findinding client

    can we find some other alternative way as its not geting for all server

  • Silverfox (9/21/2009)


    Henrico Bekker (9/21/2009)


    Narendra-587652 (9/21/2009)


    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

    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

  • 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]

  • 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..

  • 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]

  • 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.

  • 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

  • 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