SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


How to find who installed the sql server?


How to find who installed the sql server?

Author
Message
hydbadrose
hydbadrose
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2018 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!
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)

Group: General Forum Members
Points: 222485 Visits: 40371
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?

Cool
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)
Shawn Melton
Shawn Melton
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13561 Visits: 3599
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: blog.wsmelton.info
hydbadrose
hydbadrose
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2018 Visits: 934
Thank you so much for the reply, but all its showing is administrator. I want to see owner as prod\hydbadrose1...
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)SSC Guru (222K reputation)

Group: General Forum Members
Points: 222485 Visits: 40371
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.

Cool
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)
hydbadrose
hydbadrose
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2018 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.
Susan Miller
Susan Miller
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1674 Visits: 459
Did you ever find an answer?
webrunner
webrunner
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16670 Visits: 4136
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 says Can I join you?
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search