The most recent content from our members.
As there seems to be little update on progress for MSSQL Auditor support for SQL 2017, I want to ask if we can expect any approximate timeline of when this will happen ? Even on ticket support, I am left in dark over this, with no timeframe available. It's frustrating to not have support for a widely adopted SQL server…
I am currently evaluating setting up database monitoring for Solarwinds LEM and the instructions advise me to import a profiler template and then edit this template. I am using SQL Server 2016. When I import the template and select edit, I can see the imported template but ONLY when I select SQL Server 2014 as my SQL…
Hi, before I describe my problem, this is my environment: * 1 VM that runs SQL Server 2008R2 (from which I need to collect log) * 1 VM that runs Solarwinds LEM Manager appliance * 1 VM that runs SQL Profiler, LEM Agent and MSSQL Auditor (that have to collect data from the VM that run SQL Server described above) From the…
During a troubleshooting session with SolarWinds support, it was highlighted that MSSQL Auditor of SolarWinds LEM, supports log collection for only English SQL databases. This is also set in MSSQL Auditor configuration manual I. Verify the Language option and the Date/Time format: Refer to Microsoft documentation for…
I just installed MSSQL Auditor. I followed the instructions to import the template in Profiler. Now onto MSSQL Auditor: I entered the server IP and typed in the domain service account that I want to use to run this service. When i click on the button to test database connection, it immediately says the username or password…
In the cited MSDN article Microsoft discusses the deprecation of the Profiler tool for MSSQL, has anyone been planning for this yet or have any ideas how to get ahead of getting certain auditable events from MSSQL into the LEM post Profiler? We don't want to pull every MSSQL event into the LEM from all of our SQL boxes,…
Hello Everyone, Is it possible to capture any event of local SQL user creation or deletion using MSSQL Auditor? Appreciate anyone who can share guidance or configuration for this requirement?
Hello there, Cannot figure out how to configure what MSSQL Auditor sends to LEM. I have edited default SQL Profiler trace file and now I can see all events needed on agent's log file but not on LEM appliance. I just found this link:…
Hello, I'm fairly new to the MSSQL Auditor and I'm trying to get it working. I had it working with just a single server and I wanted to expand that server to monitor others. I added the other servers and told the service to run as a specific account that has Sysadmin on the servers. When I try to start, I get the error…
It looks like you're new here. Sign in or register to get started.