Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sikhest
Starting Member
2 Posts |
 Posted - 2012-01-05 : 13:48:08
|
| Hey, I'm not sure if this is possible or how to go about setting this up so please help if you can. I have two Windows 2008 servers, I would like to use one server for processing data, and the other to run the SQL 2008 DB. When I run the processing application, it creates a local database, Is there any way to have SQL on server 1 forward all requests to SQL on server 2? The application does not allow you to specify a SQL path. Basically I want SQL on server 1 to forward all SQL requests to server 2 and treat the DB on server 2 as if it was local.Is this possible at all? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sikhest
Starting Member
2 Posts |
Posted - 2012-01-05 : 13:58:46
|
| I understand this isnt normal, but it's something I've been asked to look into. Any thoughts on how to go about this? |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-01-05 : 15:21:30
|
| On server 1 - when you"creates a local database" , do you mean a SQL Server database?Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2012-01-05 : 15:22:38
|
| So, this application has hard-coded the connection information to localhost? With the expectation that you always have a local version of SQL Server installed and configured?How is this application connecting to the database? If it is using an ODBC DSN - you can change that. If it is actually hard-coded and not defined in an ini file - then your only option will be replication. Probably transactional replication will work - but that is the only thing I can think of. This will mean the local instance has all the data - and it replicates that data to server 2.Jeff |
|
|
|
|
|
|
Is This Possible??