Post reply

How can I pull out specific data from within the registry?

  • November 4, 2005 at 12:43 pm

    #95720

    Hello All,

    New to the DBA field and am learning my way through MS SQL 2000.

    What I need to find out is the company name and user name originally provided for a SQL Server  installation on a particular box.

    I did not perform the install so it could be anything.

    I manually searched the registry (HK LocalMachine\Software\Microsoft\MSSQL) with no luck.

    I did see a folder titled registration but alas it contained no information.

    I googled to no avail (although I did come across the xp_regread stored procedure but I haven't been able to get it to work for me).

    Any ideas? I need to provide the info to our corporate security team.

    Thanks in advance for any suggestions!

  • November 4, 2005 at 1:36 pm

    #602461

    G'day

    I googled "SQL SERVER READ REGISTRY".  The first link was this: http://www.4guysfromrolla.com/webtech/101499-1.shtml

    From that link:

    USE MasterEXEC xp_regread 'HKEY_LOCAL_MACHINE',                'SOFTWARE\Microsoft\MSSQLServer\Setup',                'SQLPath'
    Hope this helps
    Wayne

  • November 4, 2005 at 2:19 pm

    #602477

    Thanks for the help Wayne!

    Using your Google criteria led me here to an answer that should work: 

    DECLARE @datapath varchar(255)EXEC master..xp_regread'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion','RegisteredOwner',@datapath OUTPUTPRINT @datapath

  • November 4, 2005 at 2:23 pm

    #602479

    Just a little warning:

    The registry keys for named instances are different than for the default

     


    * Noel

  • November 7, 2005 at 8:50 am

    #602615

    I wasn't aware of that!

    Thanks for the warning...

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply