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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-02-14 : 08:24:57
|
| Swayam writes "Hi,we are in a middle of migrating sql server from current box to a new box as a part of upgrading. The new box name is different than the currentbox. When i installed sqlserver 2000, i installed 3 instances, these instances took the name of box. we will keep the new box name same as the old box but now the new box name is different because we are doing the testing and installation of different software. so for testing purposes once i restore all the databses from current box to new box, all my dts package fails because it is looking for the correct instance name. for example:my current box name is TGIthe SQl server instance name is TGI\sellingthe new box name is = T-US01when i install sql server the name of the instance - T-US01\sellingi want it to be TGI\selling inorder to make the dts package work,i ran sp_dropserver and sp_addserver, after that when i make @@servername , the out put is TGI\selling, but in the enterprise manager the instance name is still T-US01\selling.how can i change the instance name. Please help.ThanksSwayam" |
|
|
mallier
Starting Member
24 Posts |
Posted - 2006-02-14 : 11:00:34
|
| You cannot change instance names. You choose the instance name during the installation and you can only change it by uninstalling the existing instance and reinstalling a new instance of SQL Server 2000 with a new instance name.cheers,http://mallier.blogspot.com |
 |
|
|
|
|
|
SQL migration