Glad we could help (although I think the majority of the thanks goes to Gail on this one).  She asked for all of the information AND she found it being...

Quick eyeballing of that, to me it looks like it is more likely:

            
June 26, 2017 at 3:50 pm
            
#1948279

            
            
                                                
        

I am assuming based on the names that:
dummy_CustNameXRef_Delete
gets called on delete and:
ADG_CustNameXRef_Add
gets called on insert?

Also, unless I am reading those SP's incorrectly (which...

You said you posted 2 triggers, but those are procedures.
Do the triggers call those procedures?

I personally wouldn't recommend adding the name to the hosts file.  Your DNS should handle that no problem.
As for changing the IP that SQL listens on, I'm not sure...

That screenshot is a little hard to read, but if I am reading it correctly, you are using SQL 11 (ie 2012).
What is the error right below the one...

I have seen this happen if I am impatient too.  Sometimes when I load up a data source, everything starts out greyed out and if I wait about 20-30 seconds...

Another thing to look at would be filtering those results.  Is a report with 100K to 500K rows actually useful in any manner?  I am not asking if the data...

My opinion, if the upgrade to 2017 offers no features that you require, I'd stick with 2016.
The main reason for this - it has been out for a while...

I've actually seen similar things before.  For me, the issue was that SSMS had been running for a long time and I ran out of memory to display the graphics...