Apologies to be a pain but I'm relativeley new to .net programming and I need a little assistance please.
I have created a login and registration pages using the control for .net 2.0 and tested locally I can add users and login to the site.
However, once published to the server I cannot register or login as I get this 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)"
I have tried to understand the problem but cannot make any progress. There are a lot of reference to the connection string in the webconfig but I haven't added anything that wasn't there before.
Can anyone spend a little time to help me understand what I have done wrong?