aldebaran
Posts: 23
Joined: Wed Dec 05, 2007 4:04 pm
Location: Hannover, Germany
Contact:  Website

Tips for installing SQL Server Express 2005

Wed Jan 09, 2008 12:51 pm

Hi,

I spent some time to install SQL Server Express, here are my findings, the my save some work for others.

- I installed the server as part of the prerequisites

- you will need more than 256 of physical RAM (I succeeded with 512 MB), despite the MS documentation saying that you need only 192 MB. In my case I wanted to have a silent install und the server setup was simply aborted (the rest of the setup continued).
When I installed by hand the normal SQLEXPR-installer put out warning ("Hardware requirements not met") but I could continue.
Attention: if this happens the 'SQL Native Client' is already installed and will prohibit a subsequent installation of the server; you have to uninstall this first manually.

- you will find detailed logs of the setup in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\
Read the Summary.txt first. Then look in the specific log file of the component under
%ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files
(this described in the SQL Server 2005 doc)

- the silent install needs following settings:
-- Command line: -q /norebootchk /qn (as ssen in this forum)
-- Bootstrapper UI/UI level: Basic UI and progress (if you choose 'Silent install (no UI)' here, you will receive no UI and the installation takes a while longer than a normal user is waiting)

- after the installation I had the setup run a script to define the database and fill it with data by using SQLCMD (search in this forum to find something on it).

Greetings
Stefan Hackenthal
aldebaran.de

Return to “Common Problems”