« Previous Next »

Thread: Finding database information for IIS Applications

Last post 06-23-2009 10:29 AM by vineetd. 6 replies.

Average Rating Rate It (5)

RSS

Page 1 of 1 (7 items)

Sort Posts:

  • 06-19-2009, 6:57 AM

    • vineetd
    • Not Ranked
    • Joined on 06-19-2009, 10:49 AM
    • Posts 6

    Finding database information for IIS Applications

    Hi,

    I am working for a Product for which I want to find the Topology of an IIS Server. Basically right now using WMI Classes I am able to get the following information:-

     Applications (Websites) on the IIS

    Application Pool

    IIS Server itself

     However I also want to find out about the database which the applications might be using. Is there any way I can do that? Is it present in the Metabase.xml file? I doubt that there are any WMI classes for the same.

    Please help.

     Thanks,

     Vineet

  • 06-19-2009, 9:46 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,208
    • IIS MVPs

    Re: Finding database information for IIS Applications

    Application information is completely independant from any IIS setting or configuration.

  • 06-19-2009, 9:47 PM In reply to

    • vineetd
    • Not Ranked
    • Joined on 06-19-2009, 10:49 AM
    • Posts 6

    Re: Finding database information for IIS Applications

    Hi, Thanks a lot for the prompt reply. I was afraid I was going to get that answer though :( Is there any way I can come to know some detail about it? Are there any details of communication stored somewhere on the IIS? Or even if they are stored on the Operating System of the server on which IIS is installed I could get them maybe. Is there any such record present? Thanks, Vineet
  • 06-22-2009, 9:23 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,208
    • IIS MVPs

    Re: Finding database information for IIS Applications

    That application level informaiton is stored in the application, and the method used to store it is dependant on the application technology as well as the developer's preferences.  There is no consistant and reliable way for you to get this information, nor is it related to the operating system or IIS.

  • 06-23-2009, 12:14 AM In reply to

    • vineetd
    • Not Ranked
    • Joined on 06-19-2009, 10:49 AM
    • Posts 6

    Re: Finding database information for IIS Applications

    Hi, I understand your point. There cannot be a reliable way to get it. Changing tracks and moving on to specific ASP .NET Applications. I heard that the database related information about those applications i.e. the connection string information is stored in a web.config file. Do you know if this is always the case? If it is will it be possible to read this file and gather some information? Is it always present in a specific location? Thanks, Vineet
  • 06-23-2009, 9:28 AM In reply to

    • tomkmvp
    • Top 10 Contributor
    • Joined on 03-20-2003, 6:27 AM
    • Central NJ
    • Posts 6,208
    • IIS MVPs

    Re: Finding database information for IIS Applications

    While that is true, there is a section for database connection strings in web.config, you must consider that ...

    1) this section was not standardized until ASP.NET 2.0

    2) the developer is not forced to use this and may have utilized his own methods.

    I do not know how many more ways to state it, there simply is no garaunteed way to find application database information.

  • 06-23-2009, 10:29 AM In reply to

    • vineetd
    • Not Ranked
    • Joined on 06-19-2009, 10:49 AM
    • Posts 6

    Re: Finding database information for IIS Applications

     Thanks a lot for your help.

Page 1 of 1 (7 items)
Microsoft Communities