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 - 2005-12-16 : 08:06:34
|
| sudhakar writes "hi allhow to change the current working server name of sqlserver2000? it's version is 8.0. i am having the procedure for changing the name of the sqlserver 6.5. but in 8.0 i am not having ISQL_w.how can i change the name of the running server?plz give imm reply." |
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-12-16 : 09:47:40
|
| No ways. 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. |
 |
|
|
activecrypt
Posting Yak Master
165 Posts |
Posted - 2005-12-17 : 05:12:58
|
| Hi,though its not recomended do it as :http://www.databasejournal.com/img/uspRenameServer.sql or create a new instance , copy all objects to newer instance then delete old instance.HTH:-)RegardsAndy DavisActivecrypt Team--------------------------------------------SQL Server Encryption Softwarehttp://www.activecrypt.com |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-17 : 23:57:33
|
quote:
Originally posted by gkrishn
No ways. 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.
not true.After changing the server's hostname, SQL Server will not startup properly. To fix this all you have to do is rerun the SQL Server setup from the original installation CD. It will detect the problem and repair it. This is about a 15 second operation.This works for both SQL 7 and SQL 2000.-ec |
|
|
|
gkrishn
Starting Member
16 Posts |
Posted - 2005-12-19 : 06:04:44
|
| What I said was about change of Instance name.Change of hostname is something different . |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-12-19 : 09:42:18
|
quote:
Originally posted by gkrishn
What I said was about change of Instance name.Change of hostname is something different .
ok, but the initial question was about changing the hostname.  |
|
|
|
bakerjon
Posting Yak Master
145 Posts |
Posted - 2005-12-19 : 17:48:48
|
| For SQL 2000, all you have to do is change the hostname. SQL Server will restart without a problem. You then have to run the followingsp_dropserver 'old_host_name'sp_addserver 'new_host_name', 'local'That's it!EC, your solution is correct for 7.0, but MSFT made it much simpler for 2000.Jon-Like a kidney stone, this too shall pass.http://www.sqljunkies.com/weblog/outerjoin |
|
|
|
|
|
|
How to change the name of the sqlserver2000(8.0)