InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 03:48:51 GMT20http://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxNow I have done.I have changed local service account to domain account and created domain account login with windows authentication. That's it.Thank you all.Mon, 03 Dec 2012 02:22:47 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxSee this link.http://www.sqlsoldier.com/wp/sqlserver/troubleshooting-atabasemirroringerror1418Sun, 02 Dec 2012 21:08:06 GMTSQL Showhttp://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxThank you, Boss. I have tried in the way you mentioned. In configuring mirroring I left service accounts box blank. But when I click on Start Mirroring, I get an error message something like "[b][color="#FF0000"]The server network address “TCP://SQLServer:5023″ 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)[/color][/b]"I can not get the problem. Please help me.Sun, 02 Dec 2012 10:58:52 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxThe two default instances can use the same port value for database mirroring. The named instance on the second system has to use a different port since it is on the same physical hardware as the default instance.Sun, 02 Dec 2012 08:12:51 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxThank you Lynn Pettis.I want to configure mirroring default instance (Principal) to default instance (Mirror) and named instance will Witness. Principal will reside on one System and Mirror and Witness will reside on other system.Sat, 01 Dec 2012 21:57:22 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxKnowing that one system has one instance of SQL Server installed (default instance?) and another has two instances installed (a default and a named instance?), we now need to know which instances are you trying to mirror databases?Sat, 01 Dec 2012 18:04:20 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxI am using one PC for Principal and other PC for Mirror and Witness. That means there are two different hardwares. One contain one instance and other contain two instances.Sat, 01 Dec 2012 04:55:04 GMTshohelr2003http://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxIf you are talking physically different hardware (could be two separate VM's on the same box as well), then they can be the same. If the instances are on the same hardware, they need to be different.Fri, 30 Nov 2012 23:01:06 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1391618-391-1.aspxDear,I want to configure database mirroring with automatic failover option. That is why I want to make my PC as Principal and another PC as Mirror (Default Instance) and Witness (Named Instance).Now my query is should the endpoints remain same or different?Please help me.Regards,AkbarFri, 30 Nov 2012 21:11:12 GMTshohelr2003