Log shipping configuration between primary and secondary sql server

[Former Member]

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.

[Sriram2009]

Hi

Kindly go thru the link

http://scn.sap.com/thread/1996715

Thanks & Regards

Sriram

[former_member184473]

Hello,

Just to complement Marius, the following note might help you:

1101017

Log shipping on SQL Server 2005

Also, if you have a firewall between the servers, make sure the firewall is not blocking any access.

Which connection string are you using?

Regards,

Eduardo Rezende

[former_member206552]

hi

hope this helps

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locat...

http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/1b907d87-ee0d-468a-904c-d4...

best regards

marius