Can't connect using Query Analyzer

[35mph]

We are going through the process of moving SQL databases from one server to another.

Yesterday, we successfully did a TEST using these steps to rename the new server's machine name to the old server's machine name:

1. Renamed the server's machine name itself
2. In QA, sp_dropserver and sp_addserver, then select @@servername to confirm the new name. Worked OK... and could use QA.

Now, we are reverting back to the original set up (remember, the previous steps were a TEST).

We successfully renamed the new machine back to it's original machine name, and did the sp_dropserver and sP_addserver... then stopped and started the SQL Server service.

Now when we do a SELECT @@servername we get NULL... when we run SELECT * from master..sysservers we get the correct results (the original name)... BUT when I try to use Query Analyzer I get this error message:

SQL Server does not exist or access denied.
ConnectionOpen

We have stopped and started the SQL service several times, but can't seem to get to get QA to connect to this instance of SQL Server.

Any ideas?

 

[35mph]

Update... Sorry for the perhaps elementary level of my knowledge, but I did two other things that seemed to help.

First, I ran the sp_addserver command with the local parameter (sp_addserver 'SERVERNAME',local) and that took care of the select @@servername issue.

Then I did a File > Disconnect All... then re-connected successfully....

Selah...

 

[35mph]

Ooops... spoke too soon... I'm still able to get into QA ok, but I'm still getting this message on my way in.

[Microsoft][ODBC SQL Server Driver][Named Pipes]SQL Server does not exist or access denied.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionOpen()).

The connection to the server has been broken.

Do you wish to re-connect now?

If I answer Yes, I just get the same error message. If I answer No, I get into QA just fine.

Think there is some remnant of the old machine name lying around? How can I determine WHAT it can't connect to?