Link to home
Start Free TrialLog in
Avatar of Karen Wilson
Karen WilsonFlag for United States of America

asked on

SQL Error 26 - Between SQL Express 2012 and SQL Server 2008 R2

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.  

Problem:  
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?
Avatar of unknown_routine
unknown_routine
Flag of United States of America image

You have to Make sure the server machine is reachable so  DNS resolve it correctly,.

Try to ping the server machine. If you can't you have to ask your network admin to govr you access.
Avatar of Karen Wilson

ASKER

Yes, I can get to the server as it works with another set of applications and I can look at and enter data using management studio.
ASKER CERTIFIED SOLUTION
Avatar of Karen Wilson
Karen Wilson
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I figured it out by reviewing the working application.