Recently, at a client location, people got stuck up with SQL Server Installation information, as follows:

Months back SQL Server instances were installed on several servers using a domain account. The person who installed the server had discontinued his services with the company. Users were able to connect to SQL Server but did not have admin privileges. They were not added to sysadmin system role. And ‘sa’ login was disabled. The requirement here was to either enable ‘sa’ login or given admin permissions to BUILTIN\Users, and to achieve either one of them, administrative privileges were needed.

So the client needed to find out which domain user was used to install SQL Server. And they had so many administrators. So where is the SQL Server installation details like user, date, etc.

This is how I found out which user installed SQL Server:

Navigate to:  C:\Profram Files\Microsoft SQL Server\110\Setup Bootstrap\Log\<Installation Date>

(That’s the path on my VM for a SQL Server 2012 installation; path on your box may differ)

You will find this file:

1_Who_installed_SQL_Server

Open it and find the string “LogonUser”

2_Who_installed_SQL_Server

There you go ! Well, there may be other ways too, if you know them, do share here!

Amit Bansal
SQL MCM, SQL MVP
Director – eDominer Systems, Peopleware India, SQLMaestros

Follow me on Twitter | Follow me on FaceBook | Connect on LinkedIn | Google+
FB page | Know more about me

SQL Server Current isolation level
SQL Server Training, SQL Performance Tuning, Bangalore July 2014