RedditPP Mascot

RedditPP

r/sysadmin • … • u/malikdeni

Jump server or another idea for Windows Server monitoring

We have a server with personal data in MSSQL that needs to be monitored for read and write access to comply with GDPR when outsourcing companies make upgrades and maintenance via Remote Desktop. **I was thinking of getting another server that will be a jump server. Can you recommend some software?** Free or open source would be best, but 2000 one time fee or 500 yearly is acceptable also.

I tried with SQL audit but the log is too large because it logs everything that happens on the SQL server - and that is not needed. I to "record" only the administrators, not the application. Any ideas?

I can't seem to find a lot of info on monitoring from this type, which seems odd. It should be basic stuff for any company that has outsourcing, and even if it is inhouse it is still a thing that is good to have.

My idea was to install some kind of software that records the screen whenever someone is logged in, for example. It would be the simplest solution, but can't seem to find such a thing.

**tl;dr How do you monitor server access from administrators, and record their actions on a Windows 2016 Server and MSSQL 2016?**

— 0