Regresar
-
Título
Change Auditor for SQL Auditing does not work on SQL Server 2017 -
Descripción
You would like to audit Microsoft SQL Server 2017 using Change Auditor but it does not work even after everything has been properly configured.
So far this issue has been encountered with Microsoft SQL Server 2017 / 2019 only.
When looking at the Change Auditor Agent log on the SQL Server, you notice the following error:
2020-08-21 16:29:23.063 [12916][WARN][NetProLib::EventTracing::SQLTraceSession::Start(222)] Cannot find provider MSSQLSERVERTrace...2020-08-21 16:29:23.079 [12916][WARN][CSQLSink::EventConsumerThread::AddTraceSession(841)] Cannot create trace session for instance MSSQLSERVER
NOTE: The -T1906 flag which is generally required for SQL Auditing has been already set and restarting services does not resolve the issue.
Debe iniciar sesión
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.