1. Master DB_datareader

    Article: AN0001787Updated:

    Account, under which the function is called has to have database role db_datareader in the maste database in the given SQL servers.

    This can be set on particular servers in the following way.

    1. Run SQL Management Studio and logon to SQL server.
    2. Open folder Security in the Object Explorer and then folder Logins. If there is no login created on the server for the account calling the function, create a new login for it with Windows authentication.
    3. Display login properties and page User mappings. Check off database master and database role db_datareader.
    4. C.onfirm OK.

    Repeat the steps on all SQL servers, from which you want to collect the data.