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

[Roger]

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

[Sean McCown]

The firewall in vista is turned on automatically. Have you poked a hole
through the right port?
A quick test is to turn off the firewall and test it again.

"Roger" <ben.y...@gmail.com> wrote in message
news:19319130-398a-401d...@y19g2000yqy.googlegroups.com...

[Roger]

Sean,

On Vista for the Firewall, I have chosen "Allow a Program through
Windows Firewall" and added port 5022 for the Principal port and port
5023 for the Mirror port. On Windows Server 2003, I have turned the
firewall off, but I am still unable to connect. I have set the port
type to TCP. Should it be set to TCP or UDP for Microsoft SQL Server
2008?

Thanks for the suggestion, but I'm still receiving the same error
message.

All the best,

Roger

[Roger]

Note that when I restart the Windows Server 2003, I receive the
following event viewer error messages:

"The SQL Server Reporting Services (MSQLSERVER) service hung on
starting."

And,

"The SQL Active Directory Helper Service terminated with service-
specific error 3221225572 (0xC00000064)."

Along with the warning message,

"The system failed to register host (A) resource records (RRs) for
network adapter with settings:

Adapter Name: {81EF09BF-A14F-4CE2-88C5-035846E6F625
Host Name: ntitcal01
Primary Domain Suffix: <our specific domain>
DNS server list:
192.168.10.6
Sent update to server: 192.168.10.6
IP Address(es):
192.168.10.9

"The reason the system could nto register these RRs was because of a
security related problem. The cause of this could b (a) your computer
does not have permissions to register and update the specific DNS
domain name set for this adapter, or (b) there might have been a
problem negotiating valid credentials with the DNS server during the
processing of the update request.

"You can manually retry DNS registration of the network adapter and
its settings by typing "ipconfig /registerdns" at the command prompt.
If problems still persist, contact your DNS server or network systems
administrator. For specific error code, see the record data displayed
below."

So basically I'll have to contact our domain administrator and let you
know what happens.

TIA,

Roger

[Roger]

Sean,

I tried turning the firewall off, and it worked! It is really strange
because I had opened the ports in the Vista firewall to allow SQL
Server 2008 to communicate, but it still doesn't work until I turn the
firewall off completely.

Thanks again for the feedback.

All the best,

Roger