SQL Server Management Studio could not save the configuration of as server a Secondary

Dear All,
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
Rajat Jaiswal

Advertisements

One thought on “SQL Server Management Studio could not save the configuration of as server a Secondary

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s