TECHZEN Zenoss User Community ARCHIVE  

MSSQL minimum permissions

Subject: MSSQL minimum permissions
Author: [Not Specified]
Posted: 2016-07-13 15:44

Anyone know what the minimum permissions are to pull SQL data Using a full admin account works, obviously, but we would prefer to use a less priveleged domain account to pull back SQL data. Right now I only get a list of Instances; database and jobs arrays are empty when pulled with the less priveleged account.



Subject: Re: MSSQL minimum permissions
Author: John Boyle
Posted: 2016-07-18 16:17

Greetings BSchimm,

I just joined Zenoss as the new Community Engineer/Manager. We have resources to offer that will help and I will check into those and reply back.

Meantime, please post back with which version you are using. The latest version which today is Zenoss Core 5.1.4. I will also be updating the download and instructions page on the Wiki a bit this month so the information flows a better for everyone looking to work with the latest Zenoss Core.

Thank you for posting. Cheers!

John

John Boyle

Zenoss Community Engineer/Manager

jboyle@zenoss.com

Twitter: @BrandFlair



Subject: This was not related to the
Author: [Not Specified]
Posted: 2016-07-19 11:39

This was not related to the version of Zenoss I am running.

The issue was related to a GPO that does not allow my monitoring account to login to the server. This is required to be able to run the powershell script in the Windows ZenPack.



< Previous
Serviced Listening on HTTP Port 80
  Next
error after moving zenoss master server from one Subnet to other subnet ..help m ...
>