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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2011-11-10 : 12:15:01
|
| Hi all,I have what I think is a SQL Server 2000 instance on a newly-discovered server.The folder name under \Program Files\Microsoft SQL Server is .... \MSSQL$MICROSOFTBCMI'm trying to connect vai Management Studio but I cannot guess the name of the instance. If this is actaully SS 2000, does "MSSQL$MICROSOFTBCM"reflect the instance name?Thanks, John |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-10 : 13:51:56
|
| If it's SQL 2000:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstancesIf it's > SQL 2000:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\ |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2011-11-10 : 15:52:32
|
Thank you, Russell.quote:
Originally posted by russell
If it's SQL 2000:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\InstalledInstancesIf it's > SQL 2000:HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names
|
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-10 : 16:31:22
|
Welcome  |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2011-11-12 : 05:43:07
|
| Usually : MSSQL$MICROSOFTBCM is the service name , and you'd connect using "SERVER_NAME\MICROSOFTBCM"Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
Not Sure of Instance Name