Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

SQL Inventory Manager now requires less permissions for data collection. Users can collect basic information from machines without the need of a sysadmin privileges. The minimum credentials required are a valid  user name and a password to connect to a machine.

To retrieve more information users need to provide valid credentials.

 

Please refer the attached spread sheet for the minimum credentials requirement.

wmi to host SQL server

Discovery credentials try to connect and see if there's SQL instance. Service or Windows account to discover Instances.

...


Discovery without login

SIM can discover instances without login, with this method SIM only collects basic information about detected instances and it doesn't provide information on the version or edition of discovered instances. 

 

Login to Instances

To get more information you can login to discovered instances.

minimal permissions required

Discovery without login

Only basic information without accessing instances

 

only browser no info version edition