How To Fix Sql Server After Computer Name Change
Connexion with Sql Server on same machine
Old Name: DESKTOP-D305KJR
New Name: JRX1
use master
exec sp_dropserver 'DESKTOP-D305KJR';
GO
exec sp_addserver 'JRX1', local;
GO
ALTER LOGIN [DESKTOP-D305KJR\__cxne_user__]
WITH NAME=[JRX1\__cxne_user__]
GO
USE CXN_Connexion
ALTER USER [DESKTOP-D305KJR\__cxne_user__] WITH NAME=[JRX1\__cxne_user__]
GO
-- FOR EACH OF THE QUEUE DATABASES
USE CXN_Connexion_Default
ALTER USER [DESKTOP-D305KJR\__cxne_user__] WITH NAME=[JRX1\__cxne_user__]
Gateway with Sql Server on same machine
Old Name: DESKTOP-D305KJR
New Name: JRX1
use master
exec sp_dropserver 'DESKTOP-D305KJR';
GO
exec sp_addserver 'JRX1', local;
GO
ALTER LOGIN [DESKTOP-D305KJR\__gateway_user__]
WITH NAME=[JRX1\__gateway_user__]
GO
USE CXN_AdvancedServices
ALTER USER [DESKTOP-D305KJR\__gateway_user__] WITH NAME=[JRX1\__gateway_user__]