Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tasosptl
Starting Member
3 Posts |
 Posted - 2008-12-15 : 07:23:03
|
| Hi to everyone,i've been started working with SQL Server 2005 & 2000 for my job almost 6 months ago and i have a question.I wonder if there is any way to find out the default and named instances on a PC without guessing them. For example what if someone forget the named instance on a server. Is there any possible way to be written on a txt file in SQL Server installation folders? Or even via Configuration Manager?Thanks |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-15 : 08:45:21
|
| This tool gives instances available on network and local PC.http://www.codeproject.com/KB/combobox/sqlexpresscombo.aspx |
 |
|
|
tasosptl
Starting Member
3 Posts |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-17 : 04:18:53
|
| It may be that some instances have been set to hide the instance name from the network (in Configuration Manager \ Properties \Hide Instance) |
|
|
|
nroberts
Starting Member
2 Posts |
Posted - 2008-12-18 : 21:20:27
|
| I believe you can also check the machine services. They should be named according to each instance installed. |
|
|
|
tasosptl
Starting Member
3 Posts |
Posted - 2008-12-22 : 07:36:42
|
quote:
Originally posted by nroberts
I believe you can also check the machine services. They should be named according to each instance installed.
That's right. You can do this with Configuration Manager of SQL Server or even from Windows Computer Management. Thanks nroberts. |
|
|
|
|
|
|
Find out instance name(s)