Mirroring Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

High Availability (2005)

Mirroring Error

Author

Topic

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2009-03-17 : 05:24:52

Hi Experts,

I am getting error when i try to start mirroring after configuring the security settings .

TITLE: Database Properties
------------------------------

An error occurred while starting mirroring.

------------------------------
ADDITIONAL INFORMATION:

Alter failed for Database 'RKN'. (Microsoft.SqlServer.Smo)

The server network address "TCP://ast026.sprintdev.local: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)

RKNAIR

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-03-17 : 09:42:37

Step 1) Your system Firewall should not block SQL Server port.

Step 2) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Network Configuration
Enable TCP/IP protocol. Make sure that SQL SERVER port is by Default 1433.

Just to make sure follow one more step which may or may not be necessary.

Step 3) Go to Computer Management >> Service and Application >> SQL Server 2005 Configuration >> Client Configuration
Enable TCP/IP protocol.

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-03-17 : 09:44:47

If above doesn't solve your problem try this also:
http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-03-18 : 07:45:52

Make sure you restore transaction log backup in NORECOVERY MODE in Mirror Server.

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2009-04-06 : 11:19:23

quote:

The server network address "TCP://<ip address>:5022"

hi..
i think you are working in a single system with multiple instances. if this is the case, configure everything right from the starting, then at the final screen, click on "donot start mirroring" button.
then change the address as shown above. just replcae the instance name with the IP address for pronciple, mirror and witness. (but the port numbersw will be same as given).

then click on start mirroring. your issue will be resolved

Arnav
Even you learn 1%, Learn it with 100% confidence.

subbi39
Starting Member

11 Posts

Posted - 2009-04-08 : 06:55:31

yes,
if you are doing miroring on a single system with multiple instance then as sunsanvin said it works.

manxen
Starting Member

2 Posts

Posted - 2009-04-17 : 05:49:08

HI,

Just you drop your current end point and recreate.

Ex...
CREATE ENDPOINT EndPointName
STATE=STARTED AS TCP(LISTENER_PORT = PortNumber, LISTENER_IP = ALL)
FOR DATA_MIRRORING(ROLE = PARTNER, AUTHENTICATION = WINDOWS NEGOTIATE, ENCRYPTION = REQUIRED ALGORITHM RC4)

Thanks
Manish

Sundaresan
Starting Member

28 Posts

Posted - 2009-04-17 : 15:48:29

Hi,

Check the following points

1) Check whether the databases in the mirror are in "NORECOVERY" state
2) Check whether the Endpoints are started. If not use

ALTER ENDPOINT <ENDPTNAME> STATE=STARTED

3) Is all the servers, participating in mirror are in the same domain.
4) Are You configuring Witness also ?

Sundaresan.R

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources