i attached my sql dbfile to webserver in control panel of database. i checked tables for any errors but there is no problem about listing tables in hosting panel. and my hosting give me a connection string, i changed the connection string with that in web.config.but when i open my webpage, it gived this error,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 am using the connection string which is written on the control panel. the connection string is like this,workstation id=xxx.mssql.somee.com;packet size=4096;user id=user;pwd=mypassword;data source=xxx.mssql.somee.com;persist security info=False;initial catalog=mydatabasenamewhat is the problem , why my page is giving that error? how can i fix it?thanks.
View Complete Post