Urgent Help: SQL Mirroring Error : 1418

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 2008 Forums

SQL Server Administration (2008)

Urgent Help: SQL Mirroring Error : 1418

Author

Topic

vijay1234
Starting Member

48 Posts

Posted - 2014-06-10 : 01:24:00

Hi All,

I'm currently facing an issue while mirroring Same Server for Principal, Witness and mirror.

Steps Followed:
> Taken fullback copy of prod db & restored the same into witness server using non recovery mode.
> Disabled firewall settings in principal server and witness server.

Kindly advice me what are all the steps to be followed to make this mirroring success.

Here all the 3 prinicpal,mirror & witness are from different servers.
Used 'sa' account while configuring the connectivity.

Error: Alter failed for Database 'XXXXX'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.4000.0+((KJ_PCU_Main).120628-0827+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Alter+Database&LinkId=20476

------------------------------

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The server network address "TCP://XXXXXXXXXX: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)

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-06-10 : 03:40:12

are you able to ping the secodary and witness servers from your primary server?
http://www.mssqltips.com/sqlservertip/2464/configure-sql-server-database-mirroring-using-ssms/

Javeed Ahmed

vijay1234
Starting Member

48 Posts

Posted - 2014-06-10 : 05:39:06

Hi Ahmed,

Yes i can able to ping my mirror server from the principal server.

Here i am using DNS server @ configurations instead of IP address.

Is that causing the issue ?

ahmeds08
Aged Yak Warrior

737 Posts

Posted - 2014-06-10 : 07:26:22

can you follow the steps provided in the link,just to make sure that you have not missed any steps

Javeed Ahmed

vijay1234
Starting Member

48 Posts

Posted - 2014-06-10 : 09:59:11

Hi Ahmed.

Yes followed the same steps.

Still facing the issue.. :(

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources