Skip to Content
Former Member
May 22, 2013 at 07:24 AM

Log shipping configuration between primary and secondary sql server


I am configuring the log shipping between primary and secondary DB center, when i try to connect the named instance of secondary DB., it throws the following error.

Cannot connect to myserver\DBinstance

A network related or instance specific error occurred while establishing a connection to sql server. The server was not found or was not accessible. Verify that the instance name is correct and tht SQL server is configured to allow remote connections. (provider: SQL server interfaces : 26- error locating server /instance specified

Just to brief you about the configuration of DBase.

We have hidden the instance of Secondary Database and disabled the browser service as per security policy.

Can anyone provide me the solution.