I'm having a connection problem with SQL 2005 Express. I'm developing a site using VS2005 and used the Login server controls along with the Website Admin Tool so the base web.config and database we created automatically. If I run the site from with VS using the built in web server everything works fine, but if I publish the site to another server and try anything that touches the database, like logging in or registering, I get the error below:

Server Error in '/' Application.
--------------------------------------------------------------------------------

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've done some research and it seems to me that if the database is with the website folder, App_Data, that when ASP accesses it it's considered a local connection?

Anyone have any ideas on how I get rid of this error?

Thanks!
Bob

If you were unable to correct this with by allowing remote connections, then the issue is probably related to your machine.config or web.config not correctly specifying the ASP.Net Providers database that you are trying to connect to.
You can find a complete walk through of the fix at http://www.aquesthosting.com/HowTo/S...QLError26.aspx

Marc Talcott
www.aquesthosting.com

Thanks Marc, turns out the problem was that my hosting provider didn't have SQL Express installed on all their servers, the first tech support person I spoke to wasn't aware of that.

Thanks,
Bob