Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  High Availability (2008)  Error Mirroring 2005 principal to 2008 mirror

Author  Topic  sergmis Starting Member 3 Posts Posted - 2009-05-31 : 21:34:21 Hello All, got a headscratcher of a problem, I successfully setup mirroring of the adventureworks 2005 DB between my SQL 2005 production server (principal) and a SQL 2008 production2 server (mirror). Figured I was ready for mirroring production databases on my prod server. Wrong!! Restored copy of production DB and transaction log to prod2 (left it in recovering state) Started Mirror wizard on principal (prod server) click on Configure Security... and tried to connect to my mirror server instance (prod2). I get the following error (Failed to connect to server XXXXX-->This SQL Server version 10.0 is not supported...) Now I know this basically means SQL 2005 can't recognize/connect to the SQL 2008 server, But why did it work for me when I first tested it using AdventureWorks? I previuosly had verified others where able to setup mirroring between SQL 2005 and SQL 2008 Upgrading to 2008 on production server would be an added pain, plus added expense