Hi All
Can someone tell me what to do with this Error:
SQL Server Management Studio could not save the configuration of 'B1' as a Secondary.
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
The specified @.server_name (A1) does not exist.
The specified @.server_name (A1) does not exist.
The specified @.server_name (A1) does not exist. (Microsoft SQL Server, Error: 14262)
I have two sql 2005 servers A1 and B1 but the databases are setup with sql 2000 compatibility.
A1 service accounts use local system account.
B1 service accounts use domain system account.
I can easily restore a database from a shared folder on A1.
I followed this article to setup log shipping.
http://deepakinsql.blogspot.com/2007/06/how-to-configure-log-shipping-in-sql.html
did anyone come across this problem?
Hi,Check SQL servername @. both the server. Run the below query and check whether the servername is A1 and B1.
Code Snippet
select @.@.servername
If A1 is not there in the first server then rename server to A1.
|||
As Vidhya said check the server name and try configuring log shipping using local system account for both the servers as in the given link
|||THANKS GUYS.
IT WAS THE SERVER NAME PROBLEM.
No comments:
Post a Comment