SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Urgent Help: SQL Mirroring Error : 1418
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

vijay1234
Starting Member

22 Posts

Posted - 06/10/2014 :  01:24:00  Show Profile  Reply with Quote
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)


Edited by - vijay1234 on 06/10/2014 01:33:33

ahmeds08
Aged Yak Warrior

India
573 Posts

Posted - 06/10/2014 :  03:40:12  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
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

Edited by - ahmeds08 on 06/10/2014 03:41:00
Go to Top of Page

vijay1234
Starting Member

22 Posts

Posted - 06/10/2014 :  05:39:06  Show Profile  Reply with Quote
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 ?

Go to Top of Page

ahmeds08
Aged Yak Warrior

India
573 Posts

Posted - 06/10/2014 :  07:26:22  Show Profile  Send ahmeds08 a Yahoo! Message  Reply with Quote
can you follow the steps provided in the link,just to make sure that you have not missed any steps

Javeed Ahmed
Go to Top of Page

vijay1234
Starting Member

22 Posts

Posted - 06/10/2014 :  09:59:11  Show Profile  Reply with Quote
Hi Ahmed.

Yes followed the same steps.

Still facing the issue.. :(
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000