Connections no longer recognize (local)

microsoft.public.sqlserver.tools

26 Jan 2006 9:05 PM

Al Cadalzo

After upgrading to SQL2005, my legacy DTS packages do not recognize
'(local)' in Source or Destination connections. In SSMS my connection
recognizes '(local)' and it says '(local)' in Object Explorer. I can connect
queries fine by using '(local)'. However, when using 3rd party tools such
as Red-Gate SQLDataCompare if I say Server: (local) and Windows
authentication, and I click OK, it says the "SQL server does not exist or
access denied". I have to use the computer name for it to connect. I
always used (local) before the upgrade and it used to work. I have named
pipes enabled. Just curious why '(local)' no longer works. Any ideas?