Recently, I was working with the team and got stuck up with SQL Server Installation information. We got an urgent requirement to patch the physical box from Windows team.
As the server was not in production, so the server entry was missing. Since Windows team wanted to take action on it as soon as possible, we had to find out which the domain user was used to install the SQL Server.
Once we get the user details, we can quickly check with him/her the criticality of SQL Server. Based on his/her input, we can give heads-up to Windows team for patching.
To address this issue, we follow the below steps;
Go to the location: C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\Log\<Installation Date>
Search the file – “sql_engine_core_inst_Cpu64”
- Open the file and search for the keyword “LogonUser”. It will tell you show has installed the SQL Server
Hope, this will help you when you stuck in similar scenario. Happy Learning!