Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-sqlserver > #1016 > unrolled thread

Finding Local SSE2008 Instances

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  Finding Local SSE2008 Instances Gene Wirchenko <genew@ocis.net> - 2012-05-03 19:51 -0700
    Re: Finding Local SSE2008 Instances Erland Sommarskog <esquel@sommarskog.se> - 2012-05-04 08:01 +0000
      Re: Finding Local SSE2008 Instances Gene Wirchenko <genew@ocis.net> - 2012-05-04 10:07 -0700
        Re: Finding Local SSE2008 Instances Erland Sommarskog <esquel@sommarskog.se> - 2012-05-05 00:09 +0200
          Re: Finding Local SSE2008 Instances Gene Wirchenko <genew@ocis.net> - 2012-05-07 10:50 -0700
            Re: Finding Local SSE2008 Instances Erland Sommarskog <esquel@sommarskog.se> - 2012-05-07 21:19 +0200

#1016 — Finding Local SSE2008 Instances

Dear SQLers:

     I decided to install a second instance of SSE2008 on my Win7 box.
The installation went fine.

     I started up SSMS, and the new instance was not listed.  The
dropdown listing the instances did not include the new instance.

     Shouldn't SSMS be able to find them?  Isn't that what the
"<Browse for more...>" selection and the "Browse for Servers" page are
for?

     I did finally add it manually, and now, it is there for good.

     How would I find all of the instances on a system if I did not
know the names of any of them?  Is it simply a matter of looking
through disk directories?  (This strikes me as rather hokey and that I
am probably missing something.)

Sincerely,

Gene Wirchenko

[toc] | [next] | [standalone]

#1017

Gene Wirchenko (genew@ocis.net) writes:
>      How would I find all of the instances on a system if I did not
> know the names of any of them?  Is it simply a matter of looking
> through disk directories?  (This strikes me as rather hokey and that I
> am probably missing something.)
 
SQL Server Configuration Manager

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[toc] | [prev] | [next] | [standalone]

#1018

On Fri, 4 May 2012 08:01:53 +0000 (UTC), Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:
>>      How would I find all of the instances on a system if I did not
>> know the names of any of them?  Is it simply a matter of looking
>> through disk directories?  (This strikes me as rather hokey and that I
>> am probably missing something.)
> 
>SQL Server Configuration Manager

     Thank you.

     What does "<Browse for more...>" et al actually do?  It appears
to be a no-op.

Sincerely,

Gene Wirchenko

[toc] | [prev] | [next] | [standalone]

#1019

Gene Wirchenko (genew@ocis.net) writes:
>      What does "<Browse for more...>" et al actually do?  It appears
> to be a no-op.
 
Dunno. Never use it. I always type in the name of the server I want to 
connect to.


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[toc] | [prev] | [next] | [standalone]

#1020

On Sat, 05 May 2012 00:09:59 +0200, Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:
>>      What does "<Browse for more...>" et al actually do?  It appears
>> to be a no-op.
> 
>Dunno. Never use it. I always type in the name of the server I want to 
>connect to.

     Ha, ha!  That was *not* the answer I was expecting from you!

     I have been wondering what I have been missing about it.

     The form is a violation of the Law of Least Astonishment.  It
does not appear, at first glance, that one can type in one's own
choice.  Now that I know, it is not such a deal.

     Do you know how to remove a choice from the list?  I once had
some bogus entries get added, and I wanted to get rid of them.

Sincerely,

Gene Wirchenko

[toc] | [prev] | [next] | [standalone]

#1021

Gene Wirchenko (genew@ocis.net) writes:
>      Do you know how to remove a choice from the list?  I once had
> some bogus entries get added, and I wanted to get rid of them.
 
If they are not in the Registry, they must be in that configuration 
file which is your Documents folder somewhere.

Obviously, since I never use the dropdown, I don't care if there are bogus
entries.

(When I think of it, I may occasionally use the dropdown at work, if I am
to connect to a customer server, and I know that I've been there recently. 
The customer servers often have difficult names like UP09VSSQL11 and the
port number is not always 1433, and if I have not updated my hosts file,
I need to use the IP address.)


-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web