﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SQL Server 2005 Strategies  / Database mirrioring Error (Microsoft SQL Server, Error: 1418) / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Mon, 20 May 2013 10:49:55 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Database mirrioring Error (Microsoft SQL Server, Error: 1418)</title><link>http://www.sqlservercentral.com/Forums/Topic750880-361-1.aspx</link><description>An Error occured while starting Mirroring.Additional information: Alter failed for Database 'testbest_DB'.(Microsoft.Sqlserver.Smo)An Exception occured while executing a Transact-SQL staement or Batch.(Microsoft.SqlServer.ConnectionInfo)The server network address "TCP:dbserver1:5022" can not be reached or does not exist.Check the network addess name and that the ports for local and remove endpoints are operatioanalI am getting this error while star mirroring,</description><pubDate>Fri, 19 Apr 2013 03:15:38 GMT</pubDate><dc:creator>rupesh.rams</dc:creator></item><item><title>RE: Database mirrioring Error (Microsoft SQL Server, Error: 1418)</title><link>http://www.sqlservercentral.com/Forums/Topic750880-361-1.aspx</link><description>We have did that still unable to start the mirror in the server.Check the attached screenshot.</description><pubDate>Fri, 19 Apr 2013 03:07:02 GMT</pubDate><dc:creator>rupesh.rams</dc:creator></item><item><title>RE: Database mirrioring Error (Microsoft SQL Server, Error: 1418)</title><link>http://www.sqlservercentral.com/Forums/Topic750880-361-1.aspx</link><description>Guys,    The error is misleading while the solution is pretty simple and straight.. Server A --&amp;gt; principal --&amp;gt; domain\Servic_Account1Server B --&amp;gt; Mirror --&amp;gt; domain\Servic_Account2Make sure domain\Servic_Account1 has sysadmin rights on Server B and the same way domain\Servic_Account2 has sysadmin rights on Server A. Set up the mirroring again and you should be good with out any errors.</description><pubDate>Mon, 04 Feb 2013 08:36:16 GMT</pubDate><dc:creator>rderisala1</dc:creator></item><item><title>RE: Database mirrioring Error (Microsoft SQL Server, Error: 1418)</title><link>http://www.sqlservercentral.com/Forums/Topic750880-361-1.aspx</link><description>You have to create TCP endpoints on Primary and on Mirror server and then  you have to grant connect permission on both servers.</description><pubDate>Sun, 12 Jul 2009 14:39:00 GMT</pubDate><dc:creator>shahm10</dc:creator></item><item><title>RE: Database mirrioring Error (Microsoft SQL Server, Error: 1418)</title><link>http://www.sqlservercentral.com/Forums/Topic750880-361-1.aspx</link><description>See if this helps you[url]http://msdn.microsoft.com/en-us/library/aa337361.aspx[/url]</description><pubDate>Fri, 10 Jul 2009 09:18:06 GMT</pubDate><dc:creator>SA-1</dc:creator></item><item><title>Database mirrioring Error (Microsoft SQL Server, Error: 1418)</title><link>http://www.sqlservercentral.com/Forums/Topic750880-361-1.aspx</link><description>Hello All ,Can you please tell me about database mirroring configuration setupI have created principal and mirror servers and before that i have done following step Principal Server:(Which is on remote server)-take a backup-save it on principal server-copy it to mirror serverMirror Server:(Which is my local system)-Restore the database .I only restore the .Bak only and unable to restore the .log file (it gives error)After that i have done the following steps 1)Right Click +Properties+Mirroring2)Click on Configure Security+Next3)I dont want WITNESS4)Next5)It automatically display Port no [b]5022 [/b]and EndPoint : [b]Mirroring [/b]  for principal and Mirror Server respectively.6)I will give Service Account as     xxxx\administartor(for Principal)and xxxx\sarang (for Mirror)7)It gives successful message 8)But when click on [b]Start Mirroring Button [/b] following error message is displayed [b][i]The server network address "TCP://indserver.xxxx.local:5022" can not be reached or does not exist. Check the network address name and reissue the command. (Microsoft SQL Server, Error: 1418)[/i][/b]so any on ecan please send me exact solution over this</description><pubDate>Fri, 10 Jul 2009 02:14:05 GMT</pubDate><dc:creator>sarang.dalal</dc:creator></item></channel></rss>