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 2012 Forums
 Transact-SQL (2012)
 Error On SQL DB Mirroring

Author  Topic 

souvik.maitra
Starting Member

1 Post

Posted - 2014-05-12 : 14:52:24
Hello,
I have implemented SQL_Mirroring on a single system by creating two instance, it is working fine. But when I tried to implement on two different PCs it shows an error 1418. Firewall is turned off on both systems. Please help me out.
Thank you,

Souvik Maitra

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-05-12 : 16:24:06
I would suggest googling that error as this is a popular topic that has been discussed at length.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

prett
Posting Yak Master

212 Posts

Posted - 2014-05-14 : 01:10:50
Hi Souvik,

Similar questions have been answered on following sites:

http://stackoverflow.com/questions/11032937/how-to-resolve-error-1418-in-sql-server-while-mirroring
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/baa54e60-81b6-43e4-9863-c2015baba7ca/sql-server-mirroring-error-1418?forum=sqldatabasemirroring

And there is a video also: http://www.youtube.com/watch?v=9v0OW2WfoIo
Go to Top of Page
   

- Advertisement -