We recently fired up a new virtual SQL server (2008 R2) and need to start auditing sql authentication failures. I went to set it up the same as the other SQL (2008 R2 also) server, which we are auditing currently, and got this error message: You do not have permission to run 'FN_TRACE_GETINFO' when testing the Auditor connection. We have our SQL auditor program running on a separate server. I tried using the local account setting, the domain admin account, and my account to no luck.
Any help would be appreciated!
Had to give our domain admin account access in the SQL database to alter trace permissions then it went through.