kpanilkumarmca1.552494914563901E12 asked a question.
How to install MS SQL 2005 in this case?
Hi,
My installer is installing MS SQL 2005... To check the existence of SQL i am using the below code:
define SQL_EXPRESS_VERSION 9.00.4035.00
nResult = VerCompare ( strSQLVersion, SQL_EXPRESS_VERSION, VERSION );
if (nResult = GREATER_THAN) then
blnSQLExpressInstalled = TRUE;
elseif (nResult = EQUALS) then
blnSQLExpressInstalled = TRUE;
else
blnSQLExpressInstalled = FALSE;
endif;
Now the problem is, most of the systems are having SQL with 9.00.3042.00 version... so as per the code installer is trying to install SQL, but i am getting the following error while installing SQL2005:
Can anybody suggest me an idea for this? how to install SQL without issue? whether i have to uninstall the old through installscript and continue or what?
Ofcourse this forum is not the right place, but i want to know from installer side can we do anything or not?
Image file SQL error
Thanks for your replay, yes it is a SQL prompt only.... but i want to know is there any way to install SQL without any issue... i mean detecting the previous version, uninstall silently... like that....
http://support.microsoft.com/kb/909967
http://www.exforsys.com/tutorials/sql-server-2005/sql-server-unattended-installation.html