August 15, 2018 at 12:09 pm
Hi,
we have standalone default SQL server instance.
Now we are going to change the computer\servername . do we need to change the SQL instance name or will it automatically change?
Thank you !!
August 15, 2018 at 12:54 pm
adisql - Wednesday, August 15, 2018 12:09 PMHi,we have standalone default SQL server instance.
Now we are going to change the computer\servername . do we need to change the SQL instance name or will it automatically change?Thank you !!
You'll need to change it so it's updated in sys.servers as well. Then restart the service after the name change in SQL Server.
It's pretty simple - make sure to use 'local' when adding the new name:
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
go
Sue
August 15, 2018 at 1:14 pm
Sue_H - Wednesday, August 15, 2018 12:54 PMadisql - Wednesday, August 15, 2018 12:09 PMHi,we have standalone default SQL server instance.
Now we are going to change the computer\servername . do we need to change the SQL instance name or will it automatically change?Thank you !!
You'll need to change it so it's updated in sys.servers as well. Then restart the service after the name change in SQL Server.
It's pretty simple - make sure to use 'local' when adding the new name:
sp_dropserver 'old_name'
go
sp_addserver 'new_name', 'local'
goSue
Thank you !!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply