I could upgrade to Sql Server 2012 after bit of struggle, and would like to post those easy tips so that it wouldn't be so difficult when you go through this.
Easy Tips for upgrade from SQL Server 2008 R2 to SQL Server 2012
Additional Challenges if Reporting Service is configured on Existing SQL Server
If you are prompt with any more issues while dealing with upgrade, do send me a note.. happy reading!
Easy Tips for upgrade from SQL Server 2008 R2 to SQL Server 2012
- Verify Sql Server 2008 R2, Service Pack 1 or later is installed and Visual Studio 2010 SP1 is installed.
- If you are running Windows 7 Operating System machine then ensure SP1 is installed and Enterprise edition of SQL 2012 is not supported on Windows 7.
- On Windows Server 2008 Operating system , all edition of sql server 2012 is supported.
- Prior edition of SQL Server 2008 R2 can be upgraded to Same edition of SQL Server 2012 that means, you can't upgrade SQL Server 2008 R2 Enterprise edition to SQL Server 2012 Developer Edition.
- Tip: If you are running SQL Server 2008 R2 Enterprise Edition on Window 7 machine , then you can't upgrade to SQL Server 2012 by any chance. Only easy option is to uninstall the existing SQL setup and do a fresh installation of SQL Server 2012.
Additional Challenges if Reporting Service is configured on Existing SQL Server
Collation of Existing SQL Server plays an important role if you have Reporting Services configured on existing environment. Binary and Case insensitive collation are not supported while upgrading the reporting services as it tries to set it up in SharePoint configuration mode and you will receive an error.
Options to handle it
- Uninstall Reporting Services from existing environment if you can afford to run it on different machine and complete the upgrade for remaining SQL Services.
- Change the SQL Server Collation to case insensitive one, which will not be an easy option and require SQL Server 2008 R2 Setup access.
If reporting Service is running with /SQLService account then you will be required to enter the password of this account while upgrading the reporting service. If password is not available , then halt the setup and configure the existing reporting service to run with Local System account. re-run the upgrade setup and it will not prompt for password.
If you are prompt with any more issues while dealing with upgrade, do send me a note.. happy reading!
0 comments:
Post a Comment