Local Servers tab of SSMS 2005 does not show the local Database Engine instance

Question

I'm using SSMS 2005 (9.00.4035.00) on a Windows Server 2008 R2 Enterprise 64bit machine.   The Local Servers tab of the Browse for Servers window does not show the local Database Engine instance.  If I enter (local) or the server name in the Connect to Server window, I have no problem to connect to the database engine.  The Network Servers tab of the Browse for Servers window shows the instance.

Answer 1

I do not understand. Are you saying that the screen connection, the server connects but not locally connected?

---

Marco Antônio Pinheiro / MCTS - Database Developer 2008 http://marcoantoniopinheiro.blogspot.com Se o post foi útil, não esqueça de marcá-lo.

Answer 2

I have installed a default instance of SQL Server 2005 Standard Edition (64bit) with SP3 on a Windows Server 2008 R2 Enterprise 64bit machine.   When I open SSMS 2005 (9.00.4035.00) and then click Connect, the Local Servers tab of the Browse for Servers window only show the entry Database Engine but there is nothing expand or collapse.   This seems to be a known issue related to SQL Server 64bit and 64bit OS and SSMS being 32bit application and which registry being queried by SSMS.

For SQL Server 64bit running on 64bit OS, which registry should be queried by SSMS for default instance name and which registry for named instance name?

I notice that SSMS is querying the registries under HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server.