Hi all,

I've got an error in my application when I have published it up to a remote server:

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'm using membership and the ASPNETDB sql server express database which is created as default. I'm using Windows Authentication.

On my own PC it works perfectly, but when I publish to the hosted website, I get the error message above.

I don't have access to SQL Server on the remote machine and I cannot run any commands. I've been working on this for 4 days, and this is the last thing I need to sort out for the website to go live.

If anyone has any idea of what I have done wrong, please help!

Appreciate a response...

actually in ASP.NET wht i know is you can work with embeded database in asp.net on your local machine only and till the time ur not going to publish ur website or host ur website , when u want to host ur website u have to seaprate ur sql database and run it on sql server not from the aspnetdb.

http://msdn2.microsoft.com/en-us/library/ms228037.aspx
the above article will help u...
Read the "Deploying a SQL Server Express Edition Database" section of above article.

Prashant Pandey