SQL Server remote connection error
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...