from my ng post...

I found what fixed our problem.... On my test server, I had the Hide Server

box checked (Sql Server Network Utility -> TCP/IP -> Properties) ...

I 100% agree with setting the application name and having it based off of something so that when copy and pasted it changes. I don't necessarily agree if putting...

just my two cents... we can't use application roles (application covers multiple databases) and we utilize wa because the connection info isn't stored anywhere (not passed across the wire...