InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 18 Jun 2013 14:43:10 GMT20http://www.sqlservercentral.com/Forums/Topic723067-360-1.aspxThanks, I will check and revert back.Thu, 28 May 2009 03:08:30 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic723067-360-1.aspxCreate TCP endpoints using T-SQL statements and then grant CONNECT permissions to your login on both principal and mirror servers.CREATE ENDPOINT [Mirroring]STATE=STARTEDAS TCP (LISTENER_PORT=1430,LISTENER_IP=ALL)FOR DATA_MIRRORING (ROLE=PARTNER,AUTHENTICATION=WINDOWS NEGOTIATE,ENCRYPTION=REQUIRED ALGORITHM RC4)Create endpoint on both servers and then grant permissions and then use wizard.Wed, 27 May 2009 10:52:52 GMTshahm10http://www.sqlservercentral.com/Forums/Topic723067-360-1.aspx[quote][b]shahm10 (5/26/2009)[/b][hr]have you created proper tcp endpoints ?[/quote]There's a small problem infact. I created it using SSMS wizard. So for Principal it's coming as "TCP://principalservername.domainname:5022"but for Mirror "domainnam is not coming"..only "TCP://mirrorservername:5022" is coming.Why so.? Using wizard it's streight forward anyways. Nothing complicated.But Where am I doing wrong ?. Can u just brief how to create "TCP ENDPOINTS" properly.?Thanks.Tue, 26 May 2009 23:33:31 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic723067-360-1.aspxhave you created proper tcp endpoints ?Tue, 26 May 2009 15:24:02 GMTshahm10http://www.sqlservercentral.com/Forums/Topic723067-360-1.aspx[quote]I was configuring mirroring on my TEST servers.[/quote]No, both are different servers and NOT same.Tue, 26 May 2009 02:54:23 GMTJoy Smith Sanhttp://www.sqlservercentral.com/Forums/Topic723067-360-1.aspxYou say you configured this on your test server. Does that mean that the principal and the mirror databases are both on the same server? If that's the case you cannot use port 5022 for both endpoints. Change one of them to 5023 or any other free port.Tue, 26 May 2009 02:05:21 GMTMarkusBhttp://www.sqlservercentral.com/Forums/Topic723067-360-1.aspxDear All,I was configuring mirroring on my TEST servers. I could configure it succesfully (I din't configure witness server at all).But when I click on "Start Mirroring" it gives me the following error."TCP://MIRROR_servername:5022" can not be reached or does not exist.Check the network address name and reissue the command.(Microsoft SQL server, Error:1418)"First it was caoming for principal server("TCP://PRINCIPAL_servername:5022") . Then I made the mirror database in NO RECOVERY mode.After that this error is coming for MIRROR SERVER.What to do..? Pls help..And is it essential to configure witness server..?Thanks in advance.Tue, 26 May 2009 01:55:07 GMTJoy Smith San