Wednesday 4 February 2009

Issues during installing SQL Server 2008

This blog post talks about my problems with installing SQL SERVER 2008 Developer Edition in my Windows XP box.
After two failed attempts, I was finally able to install SQL SERVER 2008 in my dev box.
The below are the erros occurred in my previous attempts in installation and the root cause and corresponding solutions for them.
1. Error: “Condition:Feature dependency condition for action…… There are 10 dependant features. The feature is tested for results: ValidateResult, Result." did not pass as it returned false and true was expected.”
Root Cause: Presence of Visual Studio 2008 in my system.
Solution: The blog post of George P. Alexander Junior talks in detail about Failure of SQL Server 2008 installation due to Visual Studio 2008 presence. After reading this blog, I uninstalled all Visual Studio 2008 components to enable clean install of SQL Server 2008 in my system.
2. Error: “Access Denied”
Root Cause: Rights missing for “Debug Programs” for administrative account installing Sql Server.
Solution: The microsoft forum discussion Solution to Access Denied Error in SQL Server 2008 installation contains the solution. We have to change group policy accordingly.
After correcting the root cause issues, finally I am able to install SQL Server 2008 in my system. I am very happy about it. I think Microsoft would be including these constraints check prior to install of SQL Server 2008.
/Venkat

No comments:

How to Handle SSIS Database movement from one environment to another

Below are the steps to follow the movement of SSISDB from one environment to another: -- opening the existing Database master key in S...