1 Reply Latest reply on Jun 11, 2014 9:31 AM by seffland

    SQL Auditor problems

    seffland

      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!

       

      Thanks.