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.
-
Run SQL Management Studio and logon to SQL server.
-
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.
-
Display login properties and page User mappings. Check off database master and database role db_datareader.
-
C.onfirm OK.
Repeat the steps on all SQL servers, from which you want to collect the data.