I'm trying to replicate a database from SQL Server 2005 to SQL Server 2000, while creating a new Subscription when I try to add a subscriber server the following error message is displayed. TITLE: Connect to Server
Failed to connect to server BERN. (Microsoft.SqlServer.ConnectionInfo)
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
I did Googleing but I could not find a suitable solution, please help me out. I will be grateful to you.
modified on Monday, January 14, 2008 1:03:10 AM
Last Visit: 31-Dec-99 19:00 Last Update: 25-Nov-15 7:46