Can I Have link Between Several Servers

hello all

I have a web application(asp.net) and Database(sql server 2005) .

we have installed them on several servers.

now we want to have a connection between apllication on one server to a database on another server .

for example we have Server(A) and Server(B) the DataBases and Web apllications on two server are the same.

sometimes the Apllication on server(A) must connect to database on server(B).

whats the solution plz?

note that the number of servers can be inceased in the future this mean the number of servers are not fixed.

thanks

Not sure I follow -- do you mean you have 2 different database serves that should mirror each other, ie, the data is the same and updates on one should be mirrored on the other?

|||

You have a database in the server A .. connect to it by using ConnectionStringA , and any need data from Server B .. use another ConnectionString (e.g. ConnectionStringB).

So, in the web.config file you will have tow ConnectionStrings (A & B).. when to connect to the database in the same server use StringConnectionA and the other used to connect to the database in the another server (server B) - called ConnectionString B.

Good luck.

|||

thank you

for Contributor : i have defrerent data in each databas i cant use replication

for Participant : i must connect to different web server .

i get it that i must to use splinkserver to link servers

thanks forever.