error: 26 - Error Locating Server/Instance Specified in ASP.NET

Advertise with us

Control Panel Forum Hosting Help ASP.NET 4.5 & SQL 2012 Hosting Resources Notice

Home » Questions & Answers » error: 26 - Error Locating Server/Instance Specified

error: 26 - Error Locating Server/Instance Specified

15 Jun, 09

Author: hosam hamdi

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

did u solve this error before? if so plz contact me
thnx in advance

Answers .............

Author: Ahmed Talu

Posted Date: 24 Jun, 09

*************************************************

hosam hamdi
I'm not familiar with the error you mention. Anyway, be sure that you have not included User Instance in the connection string for SQL Server at ASPSPIDER. You are not allowed to use User Instance (unlike in the free Visual Web Developer http://www.microsoft.com/Express/ and at some paid ASP.NET hosts).

If the name of your database is xxxx.mdf then your SQL connection string at ASPSPIDER will be:
"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=orpheus_xxxx"

Do not to include file extension (.mdf) in connection strings for SQL databases. At ASPSPIDER SQL databases has to be put in the DATABASE folder, not in App_Data used on local computer (and at other hosts).

*************************************************

I have listed some stuff to remember when using SQL at ASPSPIDER http://www.aspspider.com/qa/Question4220.aspx

*************************************************

You must login to post answer for this question.

Total members: 250871
Average new registrations per day (in last 7 days): 11

New Registration: Open

Register Now

Talk to Webmaster
Tony John

Facebook
Google+
Twitter