Wednesday, October 24, 2018

How to find out who installed SQL Server?

Odd question, but it came up for me today.  Today a customer told me that I installed both SQL Server 2016 and 2017 on their instance, and they wanted me to remove v2017.  um... No.  Why would I do that?  So I took a look, and there were two full installations side by side -- but it definitely was not done by me.  I cleaned it up, and also performed the steps below, so that I could let them know this was not done by me.

First, go to this location to find your setup bootstrap logs:

At that location, you should search for this file:   sql_engine_core_inst_Cpu64.log

Open up that file and search for ' logonuser '... and there you go!  Of course, this is my installation log and not my customer's, but you get the point.  The LogonUser value corresponds to whomever was logged on while the installation is performed.

Happy SQL Servering!   ☺☺☺

No comments:

Post a Comment