Issue:

When a server is created via replication, the sql server name might need to be changed. If not, you will see login issues in the database log and unable to see the job history.

Resolution:

EXEC sp_dropserver 'xxxxxxx';
GO
EXEC sp_addserver 'xxxxxxxxxx', 'local';
GO

Remember to restart SQL Server to apply the change.

Last modified: August 29, 2023

Author

Comments

Write a Reply or Comment