Basic troubleshooting of discovery scripts

<!--[if lt IE 9]>

<![endif]-->

Comments

• Anonymous
  October 31, 2014
  I wrote about basic discovery script troubleshooting here: http://blogs.technet.com/b/kevinholman/archive
• Anonymous
  January 08, 2016
  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
  
• Anonymous
  January 08, 2016
  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 !!!