if you’ve changed your operating system hostname, you should reflect that change in sql server by updating the name in the master database. sql server doesn’t support updating the name when involved in database mirroring, replication, or clustered environments. you’ll have to remove the feature, update the name, then re-add the feature.
select * from [master].[sys].[servers] --look for server_id=0 name is pointing to server a --server_id=0 is local server select @@servername --returns(server a) exec sp_dropserver 'servera' exec sp_addserver 'serverb',local --important step --restart the local sql server service and the sql server agent service select @@servername --returns(server b) select * from [master].[sys].[servers] --look for server_id=0 name is pointing to server b --server_id=0 is local server
read more about updating the name by jugal shah.
when you're a little too careless about virtualizing your domain controllers, cloning, migrating, backing up and restoring, returning from vacation… Read More
systemd is new service manager for linux. it's a replacement for all previous init systems (sysv/sysvinit & ubuntu's upstart) and… Read More