Installing SQL Server Express

I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".

The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.

As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.

Moving to Setup forum.

Mike

|||

The warning messages are just that, warnings, and shouldn't lead to any failures. So my guess is that it might be something with the way your command line is structured. For starters, can you post your command line install (remove passwords if they are used of course)? Can you also search your install logs for the text string "value 3"? This typically follows a more informative error message if one exists.

Thanks,
Sam Lester (MSFT)

|||

Thanks for responding Sam.

If I run sqlexpr.exe without any command line arguments I get a warning but can continue. However if I use a command line it fails to install.

The command line i am using is as follows:

sqlexpr.exe /qb INSTANCENAME=myinstance DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SAPWD=mypassword

Unfortunately none of the log files contain "value 3". However:

1. Summary.txt contains the following message:

"The current system does not meet the recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.

Setup succeeded with the installation, inspect the log file completely for status on all the components. "

2. Core(Local).Log contains:

"Machine = MYMACHINE, Article = Processor, Result = 0 (0x0)
Machine = MYMACHINE, Article = PhysicalMemory, Result = 70010 (0x1117a)
Machine = MYMACHINE, Article = DiskFreeSpace, Result = 0 (0x0)"

and

"Article: Minimum Hardware Requirement, Result: Warning
Description: Minimum hardware requirements are not met, therefore, some components may not perform as expected. Action: Make sure minimum hardware requirements are met. Please refer to the readme for minimum requirements."

I'm assuming that it means that it doesn't think that the machine has sufficient memory but given the spec of it (see my previous message) then surely it should.

If you (or anyone else) has any further thoughts then I'd be really grateful because I'm stumped on this one. My only alternative is to let users loose on the full SQL install interface and there are too many for me to want to do that!!

Thanks

Brian

|||

Hi,

refer manually installtion steps

http://msdn.microsoft.com/vstudio/express/support/install/

Hemantgiri S. Goswami

|||

Hi Hemantgiri

Thanks for the link but I really don't want a few hundred "Administrative Assistants" in schools installing SQL Express manually. Using the command line to automate it will be fine except if they get the same warning i am getting because it then fails to install correctly rather than giving an option to continue.

Brian

|||

Hey Brian, I think the issue with the command line is that you haven't supplied anything for the ADDLOCAL parameter. By adding "ADDLOCAL=ALL" to the end of your command line, you should get what you're looking for. If you only want to install a subset of the product, you can take a look at the template.ini file for some examples or reply back with specific questions.

Thanks,
Sam Lester (MSFT)

|||

Spot-on Sam.

I notice that template.ini says: "If ADDLOCAL is not specified, setup will fail." I feel such a fool!!

Thanks very much for your help.

Brian