Home Forums SQL Server 2005 SQL Server 2005 Security Restoring database to another server cannot open SYMMETRIC key RE: Restoring database to another server cannot open SYMMETRIC key

  • January 5, 2009 at 2:17 pm

    #921434

    And the certificate was encrypted by the database master key and not a password? If you export the database master key from the original server and restore it on the new, can you open the database master key manually and then everything works?

    K. Brian Kelley
    @kbriankelley