locked
how do i get all Sql Server Name in my domain (network) RRS feed

  • Question

  • Hi,

    in my domain i have lot of sql server and need to patch, i am new to the organization and these is now doc which i can refer to apply patch on those server, so looking for something through i can get all sql server list so i can apply the patch, i believe in UI is there to browse in SQL management studio to connect so there must be something and lookin aroud..... 
    Friday, September 4, 2009 8:13 PM

Answers

  • i got it, and the better way to get those all sql server list with installed sql componet using OSQL , using the command  in sql command prompt c:\> OSQL -L >> Sqlserverlist.txt

    Thank You
     
    • Marked as answer by manas78 Friday, September 4, 2009 9:48 PM
    Friday, September 4, 2009 9:48 PM

All replies

  • You could probably write a script to find out which all servers are listening at port 1433 (SQL Server port). One way of doing this could be to use NETSTAT to find out open ports on a machine.


    Sunil Madan | MCDBA | MCTS
    Friday, September 4, 2009 8:47 PM
  • i got it, and the better way to get those all sql server list with installed sql componet using OSQL , using the command  in sql command prompt c:\> OSQL -L >> Sqlserverlist.txt

    Thank You
     
    • Marked as answer by manas78 Friday, September 4, 2009 9:48 PM
    Friday, September 4, 2009 9:48 PM
  • This might not be the correct list of all servers in your domain.

    http://msdn.microsoft.com/en-us/library/aa214012(SQL.80).aspx

    -L : Lists the locally configured servers and the names of the servers broadcasting on the network.


    Sunil Madan | MCDBA | MCTS
    Friday, September 4, 2009 10:19 PM
  • Just as an FYI, there's no way to get a guaranteed list of all SQL Servers, for various technical reasons.
    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Saturday, September 5, 2009 4:50 PM
  • Hi,

    You can deploy the "Microsoft Assessment and Planning (MAP) Toolkit for SQL Server 2008"  

    http://technet.microsoft.com/en-us/solutionaccelerators/dd537572.aspx


    Get a complete network-wide inventory of legacy SQL Server instances, edition identification, and hardware assessment, when you use MAP as part of a comprehensive process for planning and migrating legacy SQL Server instances to SQL Server 2008.

    With MAP you get the following reports and proposals for migration to SQL Server 2008:

    • Discovery and inventory. Identifies the various SQL Server instances in your organization.
    • Detailed reporting. Covers specific SQL Server instances that include component name, version, edition, and more.
    • Hardware and platform details. Details for computers that are running SQL Server instances including determining whether the machines are virtual or physical.
    • Identification and evaluation. Determines which existing SQL Server deployments are suitable for migration to SQL Server 2008 based on hardware and platform requirements.

    I believe you will need Domain Admin rights to run this MAP tool.


    CTD
    Sunday, September 6, 2009 12:44 AM