db mirroring error 1418 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

db mirroring error 1418

I am getting the following error when I run the command ALTER DATABASE mirroring
SET PARTNER =
‘TCP://ltihp00460.cts.com:5022’
Msg 1418, Level 16, State 1, Line 1
The server network address "TCP://ltihp00460.cts.com:5022" can not be reached or does not exist. Check the network address name and reissue the command. I ensured that 1. TCP protocol is enabled 2. Am able to ping both the servers 3. Both the server’s sql services are running under same domain account
and this account is a part of local administrator 4. checked the ports using netstat Thanks for any help

Check whether that port is blocked on the firewall or network, if any.
http://msdn2.microsoft.com/en-us/ms189127.aspx fyi. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.

Take a look at the issues/steps outlined to troubleshoot error 1418 and mirroring in the following MSDN article: http://msdn2.microsoft.com/en-us/library/ms189127.aspx Specifically check the points under the topic ‘Interpreting Error Message 1418’…
—————————————-
http://dineshasanka.blogspot.com/

Thanks for your replies…
This is the first time i am trying to test the mirroring feature.
I will go thro’ the sites you have mentioned and update you
I would suggest to refer thru books online for more information on setting up Database mirroring. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
I am getting the error 1416 database ‘xyz’ is not configured for database mirroring I don’t see much info on how to solve this one.
anyone faced this same issue before?
Whats wrong or what not is available from the above links, books online states the issue to resolve the error 1418. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
YES YES YES Its works fine.
The faults which I did… 1. I have restored the database from principal to mirror with RECOVERY Resolution:
Restore the database with NORECOVERY option.
After that restore, restore the transaction log atleast once from principal to mirror
with NORECOVERY.
The important stuff is that take separate backup files for database and log
(don’t append to the same backup medium) Thanks a ton to sathya and dineshasanka

I have the above problems too….
After try and error and some readings, i fix the problem……
Hope this help everyone:
http://alan328.com/SQL2005_Database_Mirroring_Tutorial.aspx

is Sp 2 a must for DB Mirroring?

Okay this is making me nuts… I have a couple of questions:
1. do all the servers have to have the same system account?
2. Do you have to restore at least one log backup?
-chris

Welcome to the forums.
Do you have similar problems as per above?
If not then for your questions, (1) if the both servers located on differnent domains/network then yes the account used for SQL Server services should be the same in terms of password too.
For (2) you must restore the latest database backup in order to initiate the mirroring.

Hi and I am glad to be here.
Yes I am having the same error that he process cannot connect to my mirror instance. I have followed the following process:
1. set my principal DB to full recovery
2. Did a full backup and restored to my mirror instance with no recovery
3. did a transaction log backup and restored to my mirror DB with no recovery
3. configured the security with no errors
4. tried to start mirroring and it failed the the 1418 error.
What am I doing wrong???
-chris

2. Did a full backup and restored to my mirror instance with no recovery
3. did a transaction log backup and restored to my mirror DB with no recovery
How come you can do another log backup when full backup has been restore WITH NORECOVERY option?

I thought that was what I was supposed to do…that is what the book said.
So should I recreate my DB with a full backup and NOT do the log restore?

Hi
Just take a look at URL below and follow the instruction.
Sure it works
JUST REMEMBER TO create the MIRROR ENDPOINT first
http://www.sqlservercentral.com/articles/Database Mirroring/72009/
Arash
Welcome to the forum!!
Thanks for you collaboration.
Please always check the date. This thread is 3 years old:).
Dear Luis
I knew it but I’ve left this message for whom that recently looking for the solution as i did
Mirroring was not a matter for me until the day I’ve left the message (exactly after 3 years of SQL 2008 was born) so i start searching the net and read so many questions and answers and the instruction in URL above was the best. So tried to share it to others.
By the way so many thanks for replying me and I’ll note the date. Next time I’ll describe better my meaning and what I’m doing.
Thank you for sharing science.
Hey Arash …welcome to the forums.
First of all appreciate your feedback to the post that you see most useful…thanks. Just to avoid any hot-air misunderstanding here…don’t take it in other way, by any means your participation of sharing the knowledge will definetly add a value to this site… keep going. :)
Hello Satya
Thank You
I ‘ll do my best
]]>