Click here to Skip to main content
15,881,089 members
Please Sign up or sign in to vote.
0.00/5 (No votes)

i have a web application which hosted on IIS with 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?

Hi Ravikhoda

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

Site 1:
Site 2:

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

Does this help?

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


Share this answer
ravikhoda 1-Sep-14 9:31am    
Hi, well yeah something like this but both IIS server will be installed on different dedicated server. and are not on the same machine and when i try to access database from 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?
I feel that this is called the load balancing ..

You should refer this LINK
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900