Error when trying to acces sql database

when i try to run webpage ( http://www.casasadministrapacoibarra.com), i got the next error:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)


I attached my database tothe webhosting place, and i can see correctly using SQL Server Manager Studio.


I have no idea what to do to access the database. I run it on my desktop and it works well.

 

Hi,
Can you post the connection section of your root web.config?
Comment out the passwords.
Salute,
Mark

 

I dont have any connection section, ( ot found that word with the "search text" option).
What do I need to configure?, can you give me an example please

Thanks In advance!

 

Hi,
An example is here:
http://community.discountasp.net/default.aspx?f=16&m=23157

 

I am getting the same exact error. I just signup to the hosting service today and downloaded all my app. I get the same error.


I subscribed to the sql addon and followed all the steps about adding the database to my app.


but i get that error. my conection string section is totly wrong and i thought that litle aplication on the site did the correction when I transfered from express to the regular sql 2005


What can i do? I am gone ask for refund tomorow if not solved


<connectionStrings>


<remove name="LocalSqlServer"/>


<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" providerName="System.Data.SqlClient"/>


<!--


<add name="LocalSqlServer" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|aspnetdb.mdf" providerName="System.Data.SqlClient"/>


<add name="LocalSqlServer" connectionString="Data Source=.\SQL05;Initial Catalog=TheBeerHouse_Remote;User ID=sa;Password=ok" providerName="System.Data.SqlClient"/>


-->


</connectionStrings>

 

Hi!,
Thanks!...that was the problem. It worked!


Thanks a lot!