Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver Subject: Re: Odd Server Name on Connection List Date: Sat, 08 Oct 2011 11:01:43 +0200 Organization: Erland Sommarskog Lines: 30 Message-ID: References: <2nsu87hcp8o0e8ag2blkscaj34rlrq7q9r@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx04.eternal-september.org; posting-host="nBFDv6s1VJQDuF1w6hpX2A"; logging-data="3844"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/Gto+Joh2uinDLgeP5jru5" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:ud6AsUf1InQ8R3N5ukvN/Ypo/l4= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:740 Gene Wirchenko (genew@ocis.net) writes: > I have a Windows 7 box. I installed Denali on it, and I just > installed SQL Server 2008 Express SP 3, presumably 64-bit thoughI was > not asked. > > 1) There is but one SSMS: the one for Denali. From it, I can get > into the 2008 instance. At least, I can view the names of the > databases in it. (I have not tried to go further.) This seemed odd > at first. Is it OK? I would have thought that a permanent version > would have more rank. Not sure that would the problem is. You should be able to connect to SQL 2008 and SQL 2005 from Denali SSMS. However, you will not be able to connect to SQL 2000, as Microsoft has a two-versions-back policy. > 2) The list of server names has two entries for > db2.srv.host-it.co.uk. What is this? It is not anything that I > (knowingly) added. How did the entries get there? Has my system been > hacked? I have no idea. Try to connect to them and see what happens. :-) -- 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