Basic troubleshooting of discovery scripts


<!--[if lt IE 9]>

<![endif]-->


Comments (3)

  1. Anonymous says:

    I wrote about basic discovery script troubleshooting here:
    http://blogs.technet.com/b/kevinholman/archive

  2. Dominique says:

    Hello,

    I find this article helpful but I could not finalize the same udpate for SQL MP 6.6.4.0 failing on SQL Discovery all SQL versions…

    I tried with DiscoverSQL2008DB.vbs

    Apparently it needs 7 parameters:

    ‘ Parameters that should be passed to this script
    ‘ 0 MPElement ID ({157E391B-AE98-47B4-529A-544481162729})
    ‘ 1 Target Id for ME this rule is running against ({24345584-0FD5-0FAB-2293-D4C82BEDB086})
    ‘ 2 Computer ID
    ‘ 3 Computer FQDN
    ‘ 4 SQL Connection String for the instance that the DBs are being discovered on
    ‘ 5 SQL Instance that this rule is being run for
    ‘ 6 Exlcuded database list (prefixed with Exclude:)

    I tried but nothing happened I miss 1 parameter but not sure how to do it?

    cscript /nologo DiscoverSQL2008DB.vbs {00000000-0000-0000-0000-000000000000} {00000000-0000-0000-0000-000000000000} MSQLCL1A. MSQLCL1A.ad TRANSPLANT08 Exclude:True

    Thanks,
    Dom

  3. Dominique says:

    In progress not sure of the format for the TCP and Event ID but still trying !!!
    cscript /nologo DiscoverSQL2008DB.vbs {00000000-0000-0000-0000-000000000000} {00000000-0000-0000-0000-000000000000} MSQLCL1A.ad MSQLCL1A.ad Server=TRANSPLANTxxTRANSPLANTxx;Database=TRANSPLANT;User Id=zzzzzz;Password=123456789 TRANSPLANTxx Exclude:True TCP:1433
    1 but still exiting right away !!!

Skip to main content