Note: This set up works fine with another set of applications I have installed. I sync data between a SQL Server 2008 and a local copy of SQL Express 2012 , both on my local machine and on my remote computer.
I copied the working code to another set of applications for a similar project. Everything works on my local machine. I do the set up on a remote machine and I get error 26. I can gain access to the database and its tables, and I add/delete records in it through SSMS. Yet, I cannot get my visual studio 2010 windows applications to connect to this new SQL Express database on my remote machine. I get error 26.
Again, I have another set of applications that work perfectly. Any suggestions?