How Do I Host A Website On Two Different Iis Server With Common Database?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

i have a web application which hosted on IIS with asp.net 4.0 and sql 2008 r2 database. now we need to setup the same link to different server with some other domain name but want to keep the same database on the new link from the previous server. can someone tell me how can we configure database to access from two different server?

Posted 1-Sep-14 2:23am

ravikhoda

Add a Solution

2 solutions

Add a Solution

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)

Paul McGann · Answer 1 · 2014-09-01T02:38:00

Solution 1

Hi Ravikhoda

I am assuming you want to setup 2 sites with 1 common database?

Site 1: testing1.com
Site 2: testing2.com

All you need to do is setup a new site in iis and copy the files from site testing1.com to testing2.com

Does this help?

I have made some assumptions that all servers can see each other and are o nthe same network,etc.

Thanks

Paul

Posted 1-Sep-14 2:38am

Paul McGann

Comments

ravikhoda 1-Sep-14 9:31am

Hi, well yeah something like this but both IIS server will be installed on different dedicated server. testing1.com and testing2.com are not on the same machine and when i try to access database from testing2.com it gives different errors like error 26 or error 40. so basically it can not connect to sql server from one server to other. i checked that remote connection is allowed on the sql server , tcp ip is enalbled and port 1433 is added for exception in firewall. dont know any other settings.

Paul McGann 1-Sep-14 12:48pm

Hi have you tried doing this:

On the SQL Server, open 'SQL Server Configuration Manager'.

Note: This can typically be found linked from the 'Start' menu. For example: Start | All Programs | Microsoft SQL Server 2008 R2 | Configuration Tools | SQL Server Configuration Manager.

Expand 'SQL Server Network Configuration' and highlight the 'Protocols for [InstanceName]' option.

In the right-hand window, if 'TCP/IP' currently has the 'status' of 'Disabled', right click on 'TCP/IP' and select 'Enable'.

Note: You will be requested to restart the SQL Server service to complete the configuration change.

To restart the service, you can use the same Microsoft Management Console (MMC) window. To do so, highlight the 'SQL Server Services' option at the top of the tree. In the right-hand window, you can then right click on the 'SQL Server [Instance]' entry and choose 'Restart'.

Do you manage the dedicated servers, or do you have a hosting company who looks after this?

Ranjeet Patel · Answer 2 · 2014-09-01T03:23:00

Solution 2

I feel that this is called the load balancing ..

You should refer this LINK

Posted 1-Sep-14 3:23am

Ranjeet Patel

v2