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 |
|
b009ieman
Starting Member
2 Posts |
 Posted - 2007-05-03 : 21:02:51
|
| Forgive me for this novice question, as I am new with SQL Server. I'm in the situation of consolidating two SQL Servers (namely, S1 and S2), currently in 2 separate machines M1 and M2. Suppose S1 runs off M1 and S2 from M2. My goal is to migrate S1 into M2 as another instance. Now, my questions: 1) Is it feasible to preserve the SQL Server name 'S1' after the migration into M2? 2) Can I assign M2 an additional IP address - ie. the IP address of M1 - such that M2 will have 2 IP addresses?My motivation for approaching this issue in this manner is due to the many client and utility applications. I was hoping to avoid going through these applications and changing the connection strings on their configuration files and in the worst case scenario recompiling those poorly written apps with the connection string embedded in them.Your expertise is appreciated. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-03 : 23:27:34
|
| You can put two sql instances on one server, but have to ensure that server has enough horsepower to handle them. Besides, S1 has to be named instance once moved on to M2 if S2 is default instance. You need either modify connection string or create alias on app servers and clent machines. |
 |
|
|
b009ieman
Starting Member
2 Posts |
Posted - 2007-05-04 : 12:43:28
|
| Thanks for your reply, rmiao.I wanted to refrain from modifying the connection string as this involves going through all our apps and either updating a config file, changing the command line parameters, or recompiling.Creating an alias may be a possible solution. However, if it requires going through each client machine, that seems like a time-consuming process (with the 100+ machines we have). I'll do a little more research on this topic. Thanks for the suggestion. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-04 : 22:44:19
|
| Or try add alias in dns server. |
|
|
|
|
|
|
|
|
One machine, 2 SQL Server 2k instances, 2 IP Addys