March 7, 2003 at 11:13 am
We have different remote sites with separate sql servers. All these servers have database with the same name. These are sql 6.5 servers.
Now we want to centralize them into one server and one database.
One of the developers is saying that we can create multiple IP addresses on the SAME server and create a separate instance of SQL server for each of 4 sites ON THIS SERVER, so each of the sql servers will have its own IP address.
Will this work? I feel it will not work and
may cause problems.
Your reply and help will be greatly appreciated.
Thanks
March 7, 2003 at 11:28 am
Perhaps I don't fully understand the issue, but I do know that creating SQL Server instances is not possible without SQL Server 2000, Enterprise Edition.
March 7, 2003 at 11:34 am
Multiple instances of SQL Server on one machine is a feature of SQL Server 2000 (already forgot if it was in 7). Even then it should not be used in production environment unless it is "not important" for the business at all. In any case, 6.5 does not support that feature.
March 7, 2003 at 11:51 am
Slight caveat.
You can run v6.5 as the first instance and 2000 as other instances.
It is in SQL Server 7.
Not sure you need separate IP addesses. Why not separate databases?
Not sure it shouldn't be used, but I don't recommend it either. If you've got tempdb contention, it might help.
Steve Jones
March 7, 2003 at 11:54 am
I would as an easier alternative make the old server names in DNS cnames that would point to the one centralized server's "A" record. No fuss, no muss. Plus I am curios how the developer proposes to implement multiple IP's on one NIC?
Tim C.
//Will write code for food
Tim C //Will code for food
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply