Re: ssms not seeing local sql server




Aaron,
Thanks for the additional tip.

If this doesn't change anything then something is corrupt on your system.
Because I have 64bit and I certainly see my local instances (though I
don't
recall if I ever had to "kick it" this way initially).

Here is what I did:
- "Update Local Server Registration" per your instruction. This clears out
the Database Engine list. So, now it doesnt show any instances under
Database Engine.
- I right click Database Engine>New>Server Registration. This brings up the
New Server Registration with the Server Name box on it. This Server Name box
behaves the same way (i.e. I can type in the instance name and it will work,
but if I click on the drop down, and click on "<Browse for More..>", the
local instance list is missing under the Database Engine on the Local Server
tab).

You may be correct that something may be corrupt on the system but I dont
know where else to look. Note that I have reinstalled this SQL 2005 64bit
five or six times. Every time I started from scratch all the way to the
partitions (yes, I actually repartitioned and reinstalled Win2003 R2 64bit).
I even redownloaded the SQL Install EXE file and reburn the ISO file for
Win2003 R2 64bit, just in case the install files were corrupted. I'm still
observing the same issue.

Meanwhile, I have also installed and reinstalled the 32bit version and it
worked everytime. <G> I was able to see the local instance list under
Database Engine and the Outlook Tool works without issue.

Maybe I'll revisit this again, but for now I'll have to go with the
Winserver 64bit and SQL 32bit.

Thanks for all your help.


Immanuel Sibero







"Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx> wrote in message
news:C51939E1.1475F%ten.xoc@xxxxxxxxxxxxxxxxx
Aaron,

This is on the very first step in SSMS:
- On the "Connect to Server" window, I click the dropdown for Server
Name.
- I select "<Browse for More...>. This is the last choice in the
dropdown.
- This brings me to the "Browse for Servers" window.
- Then I select the "local servers" tab.
- On this tab, there is "Database Engine". In the 64bit version, this
selection can not be collapsed to show the local instance list, but in
the
32bit version, this "Database Engine" has a plus sign to its left.
Clicking
the plus sign will show the list of local instances.

Can you try something for me?

Before you do any of this "Connect to Server" business. Open SSMS and
open
the Registered Servers tab (Ctrl+Alt+G). Right-click Database Engine
there
and choose "Update Local Server Registration"...

If this changes anything (e.g. adds servers under "Database Engine") then
try your connect to server business again.

If this doesn't change anything then something is corrupt on your system.
Because I have 64bit and I certainly see my local instances (though I
don't
recall if I ever had to "kick it" this way initially).



.

Relevant Pages

  • Re: FP Extensions not working
    ... You should Publish from your online server to your local machine...not Import. ... <Can I 'tell' FP to treat the local instance as files and only put in the ... | I am still doing this in FP2003, but working on the local site as "c:\...My ... |> FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
  • Upon startup, MSDE 2000 displays sa password in system tray
    ... I have MSDE 2000 running on my laptop. ... I get a generic message stating "Network path could not ... I noticed that my system tray icon for SQL Server Service Manager ... actually have a password set for user 'sa' on my local instance. ...
    (microsoft.public.sqlserver.msde)
  • Connecting to local instance with firewall client enabled
    ... I'm running SQL Server 2000 SP3 on my XP Pro laptop and everything ... network and enable the ISA server firewall client, ... my local instance using Enterprise Manager or Query Analyzer, ... I can connect to another instance running on a server on the network. ...
    (microsoft.public.sqlserver.connect)
  • Login failed for user domainAdministrator Microsoft SQL Server
    ... I'm using remote desktop from a VISTA PC to connect to a Windows 2003 server ... local instance of SQL Server. ... I can login to that instance without error. ... properties of any user or database I receive this error. ...
    (microsoft.public.sqlserver.security)
  • Re: FP Extensions not working
    ... publishing to the server & all was OK ... "My Web Sites" then editing in FP2003 & publishing. ... Can I 'tell' FP to treat the local instance as files and only put in the ... > FrontPage Resources, WebCircle, MS KB Quick Links, etc. ...
    (microsoft.public.frontpage.client)
Loading