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?