Post reply

SQL Instances Unknown On SQL Boxes

  • December 16, 2013 at 2:34 pm

    #287488

    While I do have a list of SQL Servers provided to me, I do not have a list of the instances. There is no real way of identifying the instances without “exploring” the server. If the default instance name is not used or there are additional instances on the server, connecting via SQL Server Management Studio will be impossible unless the instance name is provided to me or I have the ability to explore the server. Is there any other way for me to identify all the SQL Instances on a particular SQL Server box?

  • December 16, 2013 at 2:56 pm

    #1673879

    it is easy to find with powershell, follow this link

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • December 16, 2013 at 3:29 pm

    #1673891

    It can be queried from WMI I believe.

    CEWII

  • December 16, 2013 at 8:02 pm

    #1673929

    You can use the MAP toolkit to detect them:

    http://blogs.technet.com/b/mapblog/archive/2012/11/08/discovering-sql-server-using-the-map-toolkit-8-0.aspx

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • December 17, 2013 at 9:41 am

    #1674142

    That is excellent tool. Thank you !

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

Viewing 5 posts - 1 through 4 (of 4 total)

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