I just tried to deploy my asp.net website and ran into a problem. Here is the error message: "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)" It seems as if asp .net cannot find the .mdf sql database in the App_Data folder. The website and the database were created with the Visual studio 2008. Do I have to change the path in the dataset or something?
You cannot code your application to connect directly to a .mdf file you uploaded to the root. You will need to attach it to the database provided in your account. First make sure you created the database inside your hosting control panel under SQL Info Manager/MS SQL 2008. Then use this kb article to export your local database and publish it to our SQL server. http://support.Winhost.com/KB/a694/publishing-your-sql-2008-database-to-Winhost-sql-2008-server.aspx
it didn't quite work for me. I followed the steps without any problems until i published the sql server to my local folder "my documents". then i opened the sql server express studio, opened the file but after i typed in the authentication stuff like server name, username and password i couldn't connect. it connected with an errorMicrosoft SQL Server, Error 53) i think i did something wrong, because nowhere i actually pointed to the sql server on Winhost.
Whats the full error message? Typically connection problems from a person's computer to our server is almost caused by the ports 1433 or 14330 being blocked.