Instance name

Question

Instance name

premkuttan

SSCommitted

Points: 1934
More actions
October 11, 2010 at 5:45 am

#142973

Is it possible to change the instance name after installation ...... If yes what is the procedure to do that???????

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

eshueshwar Old Hand Points: 380 More actions · Answer 1

No.. there's no way to rename a SQL Server instance. You either have to re-install or install a new instance with the desired name.

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 2

Yes, you can rename the instances after installation:

sp_dropserver old_name

go

sp_addserver new_name

go

Permissions

Only members of the setupadmin and sysadmin fixed server roles can execute sp_addserver.

but its not a good practise to change the instance names after the installation. Be sure to provide the correct names while installing only.

Thank You.

Regards,
Raghavender Chavva

winash SSChampion Points: 11446 More actions · Answer 3

Yes, you can rename the instances after installation:
sp_dropserver old_name
go
sp_addserver new_name
go

This works only for the default instance - not for a named instance. Best way to go about renaming named instances is to re-install (as already mentioned above).

MysteryJimbo SSC-Insane Points: 24203 More actions · Answer 4

I could be wrong, I'm sure I have renamed a named instance before and never had any issues I couldnt overcome.

I used to do this regularly as I build development servers from a sysprepped VMWare image. I'm 100% positive I had to change at least the host name segment and I recall changing a name in full using the method mentioned above. As I say, I could be wrong.

The only issue I ever had with renaming an instance was with replication which I overcome by setting up a SQL Alias and uninstalling replication under the alias, then reinstalling under the new name.

Raghavender Chavva SSCrazy Eights Points: 8669 More actions · Answer 5

winash (10/11/2010)
Yes, you can rename the instances after installation:
sp_dropserver old_name
go
sp_addserver new_name
go
This works only for the default instance - not for a named instance. Best way to go about renaming named instances is to re-install (as already mentioned above).

As per my experience we have renamed named instances also.

Thank You.

Regards,
Raghavender Chavva

winash SSChampion Points: 11446 More actions · Answer 6

Well - it could very well be that I'm wrong then...:hehe: