Karen Wilson
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?
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I figured it out by reviewing the working application.
Try to ping the server machine. If you can't you have to ask your network admin to govr you access.