sql database connection on remote server

Posted by arti pathak on Stack Overflow See other posts from Stack Overflow or by arti pathak
Published on 2009-10-18T05:55:54Z Indexed on 2010/03/08 3:02 UTC
Read the original article Hit count: 453

Filed under:

i create my web site on asp.net and i create database in sql using inbuilt it in visual studio i use step to create database 1.right click on solution explorer then add newSqldatabase then ok then if i connect it by coding then it will work on my local PC but actuall i am making website so i want to store it on my web server then if i load databse file (.mdf) file in my web server where my all files are loaded then it is showing it 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)" so please help me and send me all step how i create database and what coding i use to connect on remote server....... Thank You......

© Stack Overflow or respective owner

Related posts about ASP.NET