October 8, 2015 at 9:16 am
Hello All,
We have one tricky situation.
We are going to install new SQL Server 2014 on Windows 2012 R2. There is a copy of this server which is running on SQL Server 2005. This one has old operating system and wont be able upgrade to SQL Server 2014.
And the problem is:
After doing some checks on 2014 we would like to change this server-name with the old server-name which is running on 2005.
So, how can we change the server-name?
Thanks all for your help in advance.
October 8, 2015 at 10:14 am
so, you have 2 separate computers one with old version of windows and sql 2005, the other windows 2012 with sql server 2014, correct?
You want the sql server instance on the new server to have the same name as the old server, correct?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 8, 2015 at 10:25 am
We would like to change the servername.
i.e New ServerName is A (2014) and old ServerName is B (2005). Then we want to rename A (2014) to B.
Never mind. We might decided not to opt for this option anymore.
October 9, 2015 at 7:33 am
EasyBoy (10/8/2015)
We would like to change the servername.i.e New ServerName is A (2014) and old ServerName is B (2005). Then we want to rename A (2014) to B.
Never mind. We might decided not to opt for this option anymore.
If the instance of sql server is a default instance then just rename the computers and reboot them
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 13, 2015 at 2:35 pm
After the server renames don't forget to change the SQL local server name too:
SELECT @@SERVERNAME
EXEC master.dbo.sp_dropserver 'OldServerName'
EXEC master.dbo.sp_addserver 'NewServerName', @local = 'local'
Restart SQL/Service
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply