Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to find who installed the sql server? Expand / Collapse
Author
Message
Posted Thursday, April 15, 2010 10:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
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!
Post #904202
Posted Thursday, April 15, 2010 10:28 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:34 PM
Points: 23,275, Visits: 31,992
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?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #904212
Posted Thursday, April 15, 2010 10:30 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 1:27 PM
Points: 859, Visits: 2,387
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
PS C:\>(Find-Me).TwitterURL
@wsmelton
PS C:\>(Find-Me).BlogURL
meltondba.wordpress.com
Post #904216
Posted Thursday, April 15, 2010 10:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
Thank you so much for the reply, but all its showing is administrator. I want to see owner as prod\hydbadrose1...
Post #904229
Posted Thursday, April 15, 2010 11:10 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 12:34 PM
Points: 23,275, Visits: 31,992
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.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #904238
Posted Thursday, April 15, 2010 2:24 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, February 18, 2014 8:31 AM
Points: 236, Visits: 934
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.
Post #904383
Posted Wednesday, July 2, 2014 10:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 8:09 AM
Points: 26, Visits: 112
Did you ever find an answer?
Post #1588544
Posted Wednesday, July 30, 2014 8:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 8:24 AM
Points: 2,351, Visits: 2,700
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


-------------------
"Operator! Give me the number for 911!" - Homer Simpson

"A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Post #1597736
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse