Then I am not sure.  Sorry about that.  I've not seen that before except when I end up with an unnamed column.
Any chance that 2 columns ended up with...

Without seeing the data, I would try something like:
BEGIN TRANSACTION;
SELECT MISCCODE FROM table;
UPDATE table
SET MISCCODE = MISCCODE + '1'
WHERE MISCCODE NOT LIKE ''
AND...

are your columns named?

That is, if you are using aggregates, are you providing an alias to the column?
Like a "SELECT SUM(dollars) FROM table" won't have a column...

Has this ever worked?
Is there a different SQL instance you can successfully connect to on the network from your local machine?

I may be mistaken on this one, but I THINK the service account not being able to talk to AD can cause that problem too.
Might want to check that...

What we do where I work is have the environment set up for the connection managers instead of for an environment.  That way, anything we deploy to test, regardless of...

OH, my bad.  But, yay, progress!

SQL browser service (I believe) uses port 1434.  Do you have that port open in your firewall (as was suggested by 

July 26, 2017 at 3:02 pm

#1952916

Since you can connect when you specify the port, I am thinking this isn't a firewall related issue.
Have you tried restarting the SQL browser service?  I beleive (but could...

I am planning on speaking soon... just need to get some demo scripts and some stuff set up.
I am hoping to do a presentation on troubleshooting service broker.  I've...

Where I work, we sometimes have an issue with orphaned users on our test systems.  We restore live user databases to test from backup when we need to troubleshoot some...