SQL Server Performance

setting up database mirroring

Discussion in 'SQL Server 2005 Database Mirroring' started by dmaddhali, Feb 3, 2006.

  1. dmaddhali New Member

    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 />
  2. indigomirage New Member


    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


  3. dmaddhali New Member

    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
  4. indigomirage New Member

    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
  5. exBK New Member

    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.
  6. satya Moderator

    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.
  7. bradsoblesky New Member

    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.
  8. zieglers New Member

    I got the same error. However, after disabling encryption option and reconfiguring mirroring, everything was just fine.

    zieglers
  9. yagar New Member

    hey, that ;-T1400 worked for me. thanks a lot.
  10. amirhg New Member

    hellow :سلام
    thanks a lot.
    God will help u in your hard days.

Share This Page