4 Replies Latest reply on Apr 23, 2019 5:55 AM by ralfs

    SQL Auditor problems


      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!



        • Re: SQL Auditor problems

          Had to give our domain admin account access in the SQL database to alter trace permissions then it went through.

          • Re: SQL Auditor problems



            I have a different Problem. We also use a central server for auditing SQL Servers. The connection test works properly but the auditor not fires up. After A while the error message says I do not have the correct permissions and should check the permissions.


            Any Idea if there are logfiles to look after?


            I reinstalled the Auditor and installed .Net 2.0 no it seems to run but it isn't:


            EventLog says:


            Thread ID: 00

            System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

            File name: 'Microsoft.SqlServer.ConnectionInfo, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

               at MSSQLAuditor.SQLTraceThread..ctor(Int32 iInst, String sSrvr, String sTDFF, MSSQLAuditor msaLog, Int32 iConnectDelay)

               at MSSQLAuditor.MSSQLAuditor.OnStart(String[] args)


            The Profiler-Template is created. and in the tdf directory.


            Kind regards,