locked
SQL Mirroring 2005 Standard RRS feed

  • Question

  • I am trying to setup sql mirroring on SQL standard 2005 sp2 and I get an error below.

    It says I need to enable trace flag 1400 during startup, but I thought this was only pre-sp2. As you can see it is definately sp2.

    Also another quick question does db mirroring only use 5022, are their any other ports?

    TITLE: Microsoft SQL Server
    ------------------------------

    SQL Server cannot create the mirroring endpoint, 'Mirroring'.

    ------------------------------
    ADDITIONAL INFORMATION:

    Create failed for Endpoint 'Mirroring'.  (Microsoft.SqlServer.Smo)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Endpoint&LinkId=20476

    ------------------------------

    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

    ------------------------------

    Database mirroring is disabled by default. Database mirroring is currently provided for evaluation purposes only and is not to be used in production environments. To enable database mirroring for evaluation purposes, use trace flag 1400 during startup. For more information about trace flags and startup options, see SQL Server Books Online. (Microsoft SQL Server, Error: 1498)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=1498&LinkId=20476

    ------------------------------


    Monday, August 25, 2008 5:06 AM

Answers

All replies

  •  

    From the above its clear that you are running RTM version of SQL Server check both principal and mirror server, both of them should be patched with SP2.

     

    Also another quick question does db mirroring only use 5022, are their any other ports?

    You can use different port numbers, 5022, 5023 are default port numbers for database mirroring.

     

     

    You can check the below link for configuring database mirroring

    Database Mirroring

    Database Mirroring FAQ

    Monday, August 25, 2008 5:23 AM
  • But when I run :

    SELECT SERVERPROPERTY('ProductLevel')

    I get SP2.
    However going http://www.sqlsecurity.com/FAQs/SQLServerVersionDatabase/tabid/63/Default.aspx I see it says "2005 'Fixed' SP2 (use this if SP2 was NOT applied yet - orig. RTM removed)" So does this mean it isn't sp2, odd...


    Monday, August 25, 2008 7:10 AM
  • Check whether all the components are patched with SP2. Try the below query.

    SELECT SERVERPROPERTY('ProductVersion')

    Make sure it returns value as 9.0.3042 (for SP2) and make sure both principal and mirror server has same edition.

    Monday, August 25, 2008 7:18 AM
  • Is it Windows Service Pack 2 or SQL Server Service Pack 2 , check the build number you are on , apply SP2 + GDR Security fix.

     

    could you post the build version by running select serverproperty('ProductVersion') on all the servers involved.

     

    -Vishal

    Monday, August 25, 2008 9:55 AM
  • Is your mirrored database is also SP2, If not upgrade with it and try again.

     

    Rest of the question seems to be answered.If Still any issue presist do let us know.

     

     

     

    BR

    Praveen Barath

     

    Monday, August 25, 2008 4:49 PM
    Answerer
  • Sorry I should have posted back, this is all fixed, the standby server wasn't sp2, it should have been but it wasn't.
    Monday, September 29, 2008 11:48 AM