setting up database mirroring | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

setting up database mirroring

Environment<img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />QL Server 2005 Enterprise in Win2k3 Enterprise on 32(x86) bit machine<br /><br />I am able to enable the Trace Flag 1400 using DBCC TRACEON (1400) GO. Only then we can able to configure for the ENDPOINTS.<br /><br />I successfully configured the ENDPOINTS for both the principal server and Mirror server .And then when I started the START MIRRORING.<br /><br />I got the error message. Please find the Message below.<br /><br />An error occured while starting mirroring.<br /><br />additional Information:<br />:..&gt;Alter failed for Database ‘KQDB’, (Microsoft SqlServer.Smo)<br /><br /> :..&gt;An exception occured while executing a Transact-SQL statement or batch<br /> [Microsoft SqlServer.Connection.info]<br /><br /> :..&gt;Database mirroring Transport is disabled in the endpoint configuration.<br /> [Microsft SQL Server,Error: 1486]<br /><br /> <br /><br />If anyone have a solution on how to setup a database mirroring environment.Please send.<br />

I’ve been encountering the same issue. I’ve set the trace flag on startup, and still have no luck.
I’ve gone through every step in the online help, verified that BOTH server instances are listening (the pids corresponds to the ports) and I cannot shake this message: "Database Mirroring Transport is disabled in the endpoint configuration." The error comes following the command: alter database AdventureWorks SET PARTNER = ‘TCP://10.0.25.72:5022’
go It does not seem to matter what port I enter, and it doesn’t matter what the IP address is. I’ve tried this on both the Mirror and on the Primary (ie – in every order). The mirroring endpoints seem be created properly. I’ve explored all steps in the msdn "Troubleshooting Database Mirroring Setup" document, checking the various system tables for status, etc. but it is to no avail. I disabled the ‘VIA’ protocol in the Configuartion Manager, one of the hints I found from the various newsgroups i’ve browsed. I am trying to mirror (without a witness) between two instances on the same server. I am well aware that this is not supported, but I need to kick the tires in a testing playground. Is this a common problem? The lack of postings with this issue indicate that it may not be, but honestly, i’m stymied. If anyone has encountered and solved this, please respond, and hopefully it will help others as well. I’ve posted this same reply on forums.microsoft.com: (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=225424&SiteID=1 ) but haven’t seen any response. Does ANYONE have mirroring working? It must be something simple, but I’m stuck. Cheers, brentj

hey brentj,
It is possible to mirror 2 instances in the same machine. we need to see that the endpoints being created have different numbers. regards,
dmaddhali
Thanks for the reply! By numbers, are you referring to port numbers? If so, then this is already the case. the primary uses 5022 and the mirror 5023. I ran netstat to ensure that the server is listening on these ports, and it is. So, I think I’m still stuck… brentj
quote:Originally posted by indigomirage Thanks for the reply! By numbers, are you referring to port numbers? If so, then this is already the case. the primary uses 5022 and the mirror 5023. I ran netstat to ensure that the server is listening on these ports, and it is. So, I think I’m still stuck… brentj

Were you able to resolve this issue? I am stuck at the same point.
Ensure the SQL Server service account has required privileges to carryon the task on all the SQL server that are involved. Do you use encrypted connections over all network libraries by certificates and SSL encryption? Do you start sql service with account that has local admin rights?
Satya SKJ
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.
When enableing mirroring you cannot use DBCC TRACEON (1400). You must set the flag through Configuration Manager. Click Properties on the MSSQLSERVER and under Advanced Tab add to the end of Startup Parameters: ;-T1400 Type exactly as shown including the semi-colon. This will enable mirroring once the server is stopped and restarted.
I got the same error. However, after disabling encryption option and reconfiguring mirroring, everything was just fine. zieglers
hey, that ;-T1400 worked for me. thanks a lot.
hellow :سلام
thanks a lot.
God will help u in your hard days.

]]>