January 13, 2011 at 5:54 pm
I will installing the sql 2005 and sql 2008 instances on cluster server. Do I have to install sql 2005 instances first and then Sql 2008 instances or it doesn't matter. Please help me out here...
January 13, 2011 at 6:16 pm
Do you really require two different versions of SQL Server in the same cluster?
What if you install only 2008 and, if you have applications that won't support it, then you can set the compatibility mode of the DB to 90 (SQL Server 2005).
January 13, 2011 at 6:20 pm
I have to install sql 2005 and sql 2008 because some of the applications works only with sql 2005. we tried that by changing 90 but it didn't work. Do you have any documents to support how to install both the versions 2005 and 2008 on failover cluster? Please help me if you have any good documents.
January 13, 2011 at 6:46 pm
I'm afraid I don't. Setting the compatibility mode to 90 always worked for me when migrating databases. I just backed the DBs up in 2005, migrated the logins, restored the DBs onto 2008, checked that compat mode was set to 90, reconfigured the apps to use the new connection string, done!
Although, I might have had issues when stalling the apps from scratch, or when moving from default instances to named instances.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply