Why doesn't my mdf database work once I have uploaded the website to the server?
Posted on 2007-12-02
I have created an ASP.net website in Visual Studio 2005, it all runs fine. BUT, i have just tried uploading it to the server where it is going to stored and all of a sudden the database won't connect. The error i get when i access a page that uses the database is as follows:
"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 thought that if you developed the database inside VS2005 that you could just upload the whole site and everythinig would work.. nieve i know!!
If anyone knows how I can get the database working, please could you let me know. I'd appreciate all help,anything you know of.