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

Find the Instance Name Expand / Collapse
Author
Message
Posted Tuesday, February 13, 2007 10:48 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
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"
Post #344737
Posted Wednesday, February 14, 2007 3:27 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
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
Post #344765
Posted Wednesday, February 14, 2007 4:28 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
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?

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #344774
Posted Wednesday, February 14, 2007 10:24 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
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"
Post #345037
Posted Thursday, February 15, 2007 3:58 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, June 9, 2014 6:02 AM
Points: 2,674, Visits: 697
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.

The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Post #345069
Posted Thursday, February 15, 2007 9:19 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 7:54 AM
Points: 3,188, Visits: 2,280
SQL Server errorlog(s) anyone ?



Regards
Rudy Komacsar
Senior Database Administrator

"Ave Caesar! - Morituri te salutamus."
Post #345200
Posted Friday, February 16, 2007 2:21 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, July 17, 2014 4:47 AM
Points: 3,352, Visits: 1,480
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
Post #345378
Posted Sunday, February 25, 2007 9:15 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
hi

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

regards
chirag



"Keep Trying"
Post #347324
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse