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.
Have you ever wondered what life might be like if the Windows 10 OS somehow had a single folder that… Read More
There could be any number of reasons for needing to flash manufacturer stock OEM firmware on a Samsung Galaxy S9… Read More
Designing e-mail solutions on a large scale can be a complex and costly challenge for a business: you need to… Read More