Day before yesterday when I was implementing Log Shipping on my production server then I got a new error which was “SQL Server Management Studio could not save the configuration of as 192.168.1.101 a Secondary. (Microsoft SQL Server Management Studio) “.
I did search on Google for this but unable to find solution then at last I just got an idea from SQL Server central’s forum http://www.sqlservercentral.com.
I just ran following command
SELECT @@SERVERNAME , serverproperty(‘servername’)
Select * from sysservers where server_id = 0
What I found the server instance name was different then Machine name. In general we keep machine name and SQL server instance name same.
So I got impression to change SQL Server name for this I did following steps
1) Run SQL statement sp_removeserver “servername” to remove existing server name
2) Run SQL statement sp_addserver “serverName”,Local to add new server name
3) Restart SQL server Services
After this I tried SQL Server Log shipping, it was implemented successfully.
Thanks & Regards