SOLVED! The problem was caused by WHERE my APP-A project was located. At my work we have shared user folders that are hosted on the network, and that is where my APP-A project was located. The problem with that is that these shared folders are not trusted by our SQL servers, so when my application ran from that location the SQL server would reject the connection. I just moved my project to my local C: drive, rebuilt it and ran it and viola! it connects to the SQL server database without issue. My APP-B project was created on my local C: drive which is why it was able to access both the local SQLEXPRESS and the SQL server databases without issue.
Sincerely, -Mark mamiller@rhsnet.org