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 |
|
rohans
Posting Yak Master
194 Posts |
 Posted - 2004-01-12 : 14:40:37
|
| I have a SQL server with the name "servername/xxx". I want to know how I can change the instance name to "servername". I currently use this server as a pulbisher in my replication process. Stopping or modifying the replication is not a problem. I tried the sp_addserver and sp_dropserver but it did not work. I want to know if running the install again will fix this and replace the instance name using the server name.All help appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-12 : 14:46:04
|
| So you just want to use the default instance then? Do you have the default instance already installed?Short answer is that you can't rename an instance. If you already have the default instance installed, then just move your databases over using BACKUP/RESTORE or DETACH/ATTACH then uninstall the named instance. If you don't have the default instance, then install it, then move the databases over.Tara |
 |
|
|
|
|
|
changing instance name