Find the Instance Name

  • Hi there

    I want to find out the sql server instance name and I cannot connect to sql server for doing this. I have access only to the C drive where sql is installed. Can i lookup any file in the sql server folder or any where else for finding out the instance name?

    Thanks

    "Keep Trying"

  • Hi

    You can find the instance name from the registry if you have access to that, at HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL. It may also be possible to find it in one of the log files created when it was installed (%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\Log\Files).

    But...

    Wouldn't it just be easier to ask the person who installed it? I'm intrigued...

    Regards,

    Duncan

  • you should be able to browse and find a list of the server/instance names. SQLPing will also do the same job. Well documented then, hope this isn't a production system?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • Hi

    Thanks Duncan & Colin.

    Duncan -

    I want this information for connecting and restoreing a db at a clients place remotely and person who has installed it has already left the place.

    Colin -

    i will look into sql ping and this is a production system

    "Keep Trying"

  • you should also be able to see the instance name in the services, my 2005 instance service shows with instance name in brackets, so i could register by ip\instancename - I only have the one sql2005 instance so have no others I can compare against.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • SQL Server errorlog(s) anyone ?

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

  • Hi

    How did you get on? I finally found the instance name for my machine in that setup files folder I mentioned. It's in the one ending in SQL.log (quite a large one). I just searched for "instance name" and there it was.

    Hope you get this sorted.

    Regards,

    Duncan

  • hi

    i got it the same way...in the setup files folder and also registry.

    regards

    chirag

    "Keep Trying"

Viewing 8 posts - 1 through 7 (of 7 total)

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