Error "provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified"

Question

Hi, my application throwing this error while running a process/feature of my app. Database(SQL Server 2005 Express edition ) is running in a remote location.
My application can connect just fine ( its a C# app ) and even I can run other features/processes of the app with out any issue as well.
I've looked through the following msdn forums
http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/21933ccf-2a8e-4f29-a237-58cb3a3dea60
http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/9354bf59-15a2-49f4-bc1f-f45371e054fc
and some others..in almost all cases this issues is occurring while attempting to connect to the database. But in my case, my app can connect to the database but losing the connections after connecting to the db.

has anybody come across this situation? or do you reckon I'm just misinterpreting the situation.

Any thoughts would be helpful.

Cheers,

Answer 1

Are you sure that the working connections and the failing ones are using the same connectionstrings?

If they are different and the one used by the method that is failing is incorrect, you would get this error.

//Michael

---

This posting is provided "AS IS" with no warranties.