Post reply

Database Mirroring

  • January 20, 2011 at 12:48 pm

    #1276207

    fransantana (1/20/2011)

    when I try to configure database mirroring, connecting the mirror server instance I receive this message:

    "this version of microsoft sql server management studio can only be used to connect to sql server 2000 and Sql Server 2005 servers"

    the principal is sql server 2005 and the mirror sql server 2008 R2

    Please help me...

  • January 20, 2011 at 1:27 pm

    #1276233

    You cannot mirror between servers of different versions. They must be the same version (both SQL 2008 R2)

    And the version of management studio you are using is SQL 2005. You cannot connect to a SQL 2008 R2 instance from Management Studio 2005. Install management studio 2008

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply