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 ;) 

Answer 1

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?

Answer 2

@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

<add name="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 :( 

 

Answer 3

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.