question

Laxman 1 avatar image
Laxman 1 asked

Data Mirroring Issue on SQL 2008 R2

Hi, Trying to setup data Mirroring on 2 different server. It's showing me the below issues. Can anyone please help me with this..!! > Error: > TITLE: Database Properties > ------------------------------ > An error occurred while starting mirroring. > ------------------------------ > ADDITIONAL INFORMATION: > Alter failed for Database 'WSS_Content_c0bd0325715e4f1c8841f7e9bfd603f1'. (Microsoft.SqlServer.Smo) > An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) > The server network address "TCP:// APPRDDBS02.asset-point.com:5022" can not be reached > or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
sql-server-2008sql-server-2008-r2
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
WilliamD avatar image
WilliamD answered
I may be pointing out the obvious here, but is the server accessible via TCP/IP? The error message talks about the address and port possibly being inaccessible. It may be a good idea to check if windows firewall is blocking the port (5022) too.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Laxman 1 avatar image Laxman 1 commented ·
Thanks for your reply Willam...But still getting the same error. TCP/IP is working good and Firewall is also good (disabled the firewall settings).
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.