Page 1 of 1

Problem with install sql server 2008 Express

Posted: Tue Nov 16, 2010 1:53 am
by hmdsadeghian
Hi. I wanna install sql server 2008 express, that i checked the sql server 2008 express Sp1 in runtime application. But when i compile the project and run,don't action and sql server don't installed.in this project, i add a file to project and checked the runtime application.this file copied to desktop but when install the sql server do anything until terminate the project.

Thanks.

Re: Problem with install sql server 2008 Express

Posted: Tue Nov 16, 2010 3:26 pm
by mills
When you run the installer, does it display as a pre
SQLxpress2k8asPrereq.png
SQLxpress2k8asPrereq.png (44.53 KiB) Viewed 8331 times
req?

If so, do you get an error?

If not, is it already installed?

If you have a suitable edition, you can try to debug or add messageboxes to determine what's going on.

Re: Problem with install sql server 2008 Express

Posted: Sat Nov 20, 2010 12:41 am
by hmdsadeghian
Thanks.
no,don't display this page.After copying files,system do anything and sql server not installed.
In debug mode,insert breakpoint on install sql server script, when setup stopped on this point and i press step over,system do anything and sql server not installed.I do receive any error message. I've waiting for 30 minute but do anything.
After this time,terminate setup.

Re: Problem with install sql server 2008 Express

Posted: Wed Nov 24, 2010 9:57 pm
by mills
Is there any SQL server installed ahead of time?

Are you able to install SQL through its installer or command line?

Re: Problem with install sql server 2008 Express

Posted: Tue Nov 30, 2010 6:15 am
by hmdsadeghian
I've installed 2 instance of sql server (2000,2008).
I can install with command prompt or Sql server installer, but cannot install with my setup/

Re: Problem with install sql server 2008 Express

Posted: Tue Nov 30, 2010 4:27 pm
by mills
How does the successful command line run compare to the line in the setupSQL script:

Set Variable SQL2008R2_COMMAND_LINE_X86 to /q /ACTION=Install /SECURITYMODE=SQL /SAPWD="Sq1S#rv$r" /INSTANCENAME="SQLEXPRESS" /FEATURES=SQLEngine,Replication,SDK /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /SQLSYSADMINACCOUNTS="$SQL_COMPUTER_NAME$\$SQL_USER_NAME$" /IAcceptSQLServerLicenseTerms=TRUE

You may need to modify that to suit your needs. You can edit the MSIcode or go through the OPTIONS button in the runtimes view...

Re: Problem with install sql server 2008 Express

Posted: Thu Dec 02, 2010 3:34 am
by Bar_BQ
I had lots of problems with sql server, and what I did was I downloaded the latest sql server setup from microsoft and replaced existing setup in IADIR.

Regards,
BARBQ

Re: Problem with install sql server 2008 Express

Posted: Thu Dec 02, 2010 3:54 pm
by mills
That reminds me, there was an issue installing SQL Server 2008 Express with IA 9x that's been resolved in IA 10.