April 15, 2010 at 10:16 am
Can some one please provide me the script to find who installed the sql server and if it is a group account then how to find the member..
I typed
select createdate, loginname from sys.logins where where sid = 0x010100000000000512000000
the result I am getting is the NT Authourity\system but I want to get the member of that type. Supposed if I installed and my id id prod\hydbadrose1 then it should appear my id. Please help!
April 15, 2010 at 10:28 am
I may be wrong, but having just looked at the log files and such from installing SQL Server 2008, I don't think there is anything to tell you after the fact what user installed SQL Server.
I have to ask, why are you asking?
April 15, 2010 at 10:30 am
Where did you pull that SID number from? That type of information is not going to be found in SQL Server system databases. You will have to look at the OS Event logs. Another place would be the setup Summary.txt log generated at install. Viewing this in Explorer you can view who the owner of the file is that created it. This should show the user that executed setup.exe for SQL. {If everyone knows your local Admin password though your SOL}.
Can be found on most installations in:
<drive letter>:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
April 15, 2010 at 10:49 am
Thank you so much for the reply, but all its showing is administrator. I want to see owner as prod\hydbadrose1...
April 15, 2010 at 11:10 am
hydbadrose (4/15/2010)
Thank you so much for the reply, but all its showing is administrator. I want to see owner as prod\hydbadrose1...
Still looking for an answer to why you are looking for who installed SQL Server.
April 15, 2010 at 2:24 pm
We work for some government contract and the the audit people asked this question to make sure if we have a seperate account for software installation.
July 2, 2014 at 10:23 am
Did you ever find an answer?
July 30, 2014 at 8:00 am
If you still need this info (and if it hasn't been wiped out or otherwise lost), perhaps there is a parallel system that logged this info - OS for the storage (i.e. record in the data files created), or as others said, OS event logs. But that is just a wild guess on my part.
Good luck.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply