Failed to connect to server Microsoft.SqlServer.ConnectionInfo for database mirroring

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi,

Presently I am attempting to setup a database mirroring system using
asynchronous mirroring with MS SQL Server 2008 as the primary server
and MS SQL Server Express 2008 as the mirror server. The primary
server us running MS Windows Server 2003 and the mirror server is
running MS Windows Vista.

The mirror server can connect to the primary server, but when I
attempt to have the primary server connect to the mirror server, I
receive the following error message:

Failed to connect to server Microsoft.SqlServer.ConnectionInfo 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 that SQL
Server is configured to allow remote connections. (provider: Named
Pipes Provider, error: 40 - Could not open a connection to SQL Server)
(Microsoft SQL Server, Error: 2)

I have ensured that the SQL Browser along with the main SQL Server
services is running on both the primary server and the mirror server.
I have also configured the SQL Server Express 2008 edition to so that
TCP/IP protocol status is enabled for the SQL Server Network
Configuration -> Protocols for SQLEXPRESS setting.

Does anyone have any suggestions?

TIA,

Roger
.

Relevant Pages

  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Memory issues with 64-bit SQL Server 2005 on 64-bit Win 2003 C
    ... I also checked the individual patch levels for the .NET drivers, SQL Server ... The SQL Server is fully patched, however Windows Update reported that the OS ... Lock pages in memory -- I guess you might have taken care of it as well. ...
    (microsoft.public.sqlserver.clustering)
  • RE: migrating from wmsde to sql server
    ... Click Start, point to All Programs\Microsoft SQL Server, and then click ... then click New SQL Server Registration. ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: SBS 2003 Unable to connect to database STS_Config
    ... Uninstall the SQL server from the SBS 2k3 server from add/remove programs ... Uninstall Microsoft SQL Server Desktop Engine (SHAREPOINT) ... If AV software install any extra IIS virtual directory, ...
    (microsoft.public.windows.server.sbs)
  • Re: Best replication architecture?
    ... Looking for a SQL Server replication book? ... So if it is subscribing to Publisher 1, ...
    (microsoft.public.sqlserver.replication)