How to host two app on VPS for different SQL server databases?

Question

0.00/5 (No votes)

See more:

I've created asp/c# app for input data into sql server database. I have installed SQL server on VPS and implement app in Deafult site. My server name is server and website address is server.mydomain.com/app1, also that's full name of server, without app1.
Now I've developed another database and another asp app for input data into DB.
Question is how to implement second app on same VPS?

What I have tried:

I don't have experience with this, I'm learning.

Posted 31-Jul-17 22:56pm

marieee

Add a Solution

Comments

marieee 1-Aug-17 15:04pm

My problem is how to implement two app with two different databases in Default website on Virtual Private Server.

virusstorm 3-Aug-17 9:37am

Who is your hosting provider? Is your VPS running IIS? Unfortunately, your question is very unclear and it will be very hard for anyone to help you out. You may want to ask your hosting provider if they have any documentation on hosting multiple sites on your VPS.

marieee 3-Aug-17 11:32am

Yes, VPS is running IIS. Hosting provider told me that I have to do it myself. Why do you think that my question is unclear?

virusstorm 3-Aug-17 13:01pm

The way you've described the problem, it's unclear what you are trying to accomplish. You also didn't explain in enough detail your setup, making it difficult to offer advice or suggestions.

If I'm understanding you correctly, you have a SQL Server running on the same server as your web server, which is IIS, and now you want to add another application to it. You will need to setup another virtual directory or website inside of IIS. What is still unclear is who is your hosting provider, so I'm going to assume that you can RDP directly into the VPS. If that is the case, start here:
https://technet.microsoft.com/en-us/library/cc753729(v=ws.11).aspx

marieee 3-Aug-17 14:39pm

Yes, you understood correctly. I have SQL Server running on the same server as my web server, which is IIS. There is already one website with application connected to SQL Server. Now I want to add another application to it. I'm connecting remotely directly to VPS.
The problem with this website you send me like solution is host names. There is, for example, www.contoso.com or marketing.contoso.com. Only address that I have is server name, which is server.mydomain.com and I don't know how to change it in bindings.

virusstorm 3-Aug-17 14:43pm

The documentation uses www.contoso.com and marketing.contoso.com as examples. So you will either need to setup an additional domain or sub-domain. If you can't do this, your only other option is setup a virtual directory.

https://msdn.microsoft.com/en-us/library/bb763173(v=vs.100).aspx

marieee 3-Aug-17 15:04pm

Thanks! Just one more question. I have to write two different web.config files and save them in app folders?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)