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__]

Connexion

How To Fix Sql Server After Computer Name Change

Analytics

Connexion with Sql Server on same machine

Gateway with Sql Server on same machine

Related content