December 13, 2007 at 3:48 am
While configuring the Mirroir Option i am facing error 1418
i am using sql 2005 with domain
I need a clear steps to setup the mirroring
December 14, 2007 at 10:06 am
This is a comprehensive walkthrough step by step.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1199004,00.html#setup
In summary the steps consist of:
1: backup the db
2. Restore the db on mirror
3. configure mirror through wizard on principal.
December 15, 2007 at 3:10 am
Hi,
AFAIK error 1418 usually caused by two things:
1. Inapporpiate credentials - make sure both server have access to each other.
2. (more likely) You made your initial restore without the NORECOVERY clause.
Other feature which makes mirroring a true fun: the servers should have a FQDN, that is, in System Properties, at Computer Identification, where you can change the computername, there's a domain suffix box, it should be filled out, otherwise the mirroring will fail...
-- Erik http://blog.rollback.hu
December 16, 2007 at 12:16 am
Ensure that the mentioned port is not blocked by Firewall also if possible create an endpoint using different port number. Pls refer the below link,
http://msdn2.microsoft.com/en-us/library/aa337361.aspx
http://sql-articles.com/articles/cng-dbmrr.htm
[font="Verdana"]- Deepak[/font]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply