Deploying ASP.NET WebForms Application with MSSQL Server

Question

At last my program is already finished and now it's time to deploy it to be accessed on the internet. Can someone send me links on how to do this? What should be my connection string and how should I setup my IIS. By the way the database is hosted in the office. A million of thanks ;)

Ramesh Palanivel · Answer

Hi HoldOn Yes What I am trying to tell you some times the server machine cannot access by other users which mean the server machine may act as local server machine. It want to be act as public server machine. Then only we can access our application in internet. Have understand it now?

Hold On · Answer

@Ramesh Palanivel thanks for your quick reply. 1. Yes I am using MSSQL SERVER and it's already installed on the server. 2. Supposing the local ip address of my server is 192.168.1.20 then the connection string should be DBConnectionString connectionString= Data Source=192.168.1.20;Initial Catalog=HQDB;Persist Security Info=True;User ID=sa;Password=xxxxx providerName= System.Data.SqlClient /> Am I correct? 3. What do you mean by this:  your server machine should be have public IP access. then only you can access your application on internet. if not is made like that you cannot access the application in outside of the organization. We have acquired a static public IP. 4. Yes...still learning until now :(

Ramesh Palanivel · Answer

Hi HoldOn Yes. Its very simple. First you have to focus on some few things. 1. If you want to deploy your application with mssql server you should have to install the mssql on server machine. or if you have an sql server on anyother machine  you can map it using IP address of the particular machine. Note : the server machine should have access for that machine. to test that  just open cmd prompt and type ( ping IPaddressofthemachine) 2. Configure the correct sql server details in your web config connection string. 3. your server machine should be have public IP access. then only you can access your application on internet. if not is made like that you cannot access the application in outside of the organization. 4. Learn the IIS configuration and methods details in internet.