Re: ssms not seeing local sql server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance


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.



Thanks for your help,

Immanuel Sibero.


"Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx> wrote in message
news:C5192DCC.1473C%ten.xoc@xxxxxxxxxxxxxxxxx
I have to believe that this could be an issue between the 64bit and the
32bit versions since the Outlook tool is not the only one having a
problem
with listing local instances, SSMS itself can not detect the local
instances
under the "Local Servers" tab.

Is this before or after you right-click "Local Server Groups" > Tasks >
Register Local Servers? This should happen for you automatically but I've
read several people say that they've had to "kick it," so to speak.



.

Relevant Pages