Problem description / Issue description
When you are trying to do certain activies* with the SQL Server Security Agents you receive the error: "Trace-file creation return code = -12".
- Creating a new monitor
- Copying (cloning) an existing monitor
- Importing a monitor
- Modifying an existing monitor
This problem is in most of the cases related to:
- Permission issues
- The SQL user (or Windows Builtin user) that is trying to create the TRACE file into the remote Windows that hosts the SQL Server that's being monitorized doesn't have enough permissions to do so.
- The SQL user (or Windows Builin user) that is trying to create new traces into the SQL Server Engine can't do it.
- Corruption of the Tango_Traces table (located into the master database of the SQL Server Engine that's being monitorized) or the SQL Server traces.
- Problems with configuration of the PATH where we want to create SQL Server traces (for example if it doesn't exist and can't be created).
If it's related to a permission issue, you should try to verify that every permission/authorization is properly configured.
If it's NOT related to a permission issue, then do the following procedure:
- Edit the monitor and modify the Path with an existing and valid Path in the remote SQL Server
- Export all the monitors related to this remote SQL Server from the Thinkserver Configurator visual interface
- Delete all the exported monitors in the step 2, and also all the related DataSources (this should delete any remote trace into the remote SQL server)
- Go to the remote SQL Server and verify that the table Tango_Traces into the master Database is empty, if not, delete all entries in it
- Import the monitors exported in the step 2 into your Thinkserver Configurator and start them
You can check the Chapter 4 of the User Guide of the SQL Server Security Agents related to the minimum permissions required to run the agents.
You can also, look at this KB entry that shows a SQL code to automate the SQL traces cleaning-up.