I have imported the SQL 2014 management pack, Configured the SQL Action Account with the relevant security rights but for some reason I just can’t get rid of these two Alerts. Any ideas or suggestions would be appreciated. My SQL Action account has SysAdmin rights
Local Admin Security Rights
SysAdmin Security Rights
Did you assign an account for the discovery/monitoring run as profile as well? Don’t forget local permissions on the SQL servers as well, this is often forgotten. The SQL Management Pack guide explains in detail which permissions are required for SQL monitoring, suggest you go through that as well.