Installing SQL Express from command prompt

I'm attempted to run an installation of SQL Express 2005 from the
command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
now want to get my hands on setup.exe, template.ini, etc.. that I will
run from the command prompt. I can see them being created in a
temporary folder when I launch SQLEXPR32.EXE, but they cannot be
accessed or copied because they are in use, and when I quit the GUI
installer all the files disappear.
Anyone out there had any success a doing this with Express?
See the following article on how to install SQL Server 2005 from the command
prompt:
http://msdn2.microsoft.com/en-us/library/ms144259.aspx
Towards the end of the article you will see all parameters that can be
configured to create an installation ini script.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
|||On 28 Feb, 16:31, "Plamen Ratchev" <Pla...@.SQLStudio.com> wrote:
> See the following article on how to install SQL Server 2005 from the command
> prompt:http://msdn2.microsoft.com/en-us/library/ms144259.aspx
> Towards the end of the article you will see all parameters that can be
> configured to create an installation ini script.
> Regards,
> Plamen Ratchevhttp://www.SQLStudio.com
read it already. Have you installed Express from the command prompt
successfully? Like I said in original post I can't get hold of all
the files that are generated by running the redistributable. I could
get hold of the setup.exe and build my own ini script but won't I be
missing files?
|||Yes, I have installed successfully SQL Server Express from the command
prompt. You do not need to access directly the extracted files. The
compressed installer file (SQLEXPR32.EXE) supports the same command line
parameters as setup.exe. Actually it will just pass the parameters to
setup.exe once it is extracted onto the hard drive.
Regards,
Plamen Ratchev
http://www.SQLStudio.com
|||Si,
It is necessary to include the full path name of the ini file in quotes:
SQLEXPR32.exe /qn /settings "C:\MyDir\command.ini"
Also if the install had failed earlier it is necessary to go to Add/Remove
programs and clean outany Microsoft SQL progams before re-running this.
One culprit is "Microsoft SQL Server Native Client" that remains after a
failed install.
Scott
"Si" wrote:

> I'm attempted to run an installation of SQL Express 2005 from the
> command prompt. I've downloaded the redistributable SQLEXPR32.EXE and
> now want to get my hands on setup.exe, template.ini, etc.. that I will
> run from the command prompt. I can see them being created in a
> temporary folder when I launch SQLEXPR32.EXE, but they cannot be
> accessed or copied because they are in use, and when I quit the GUI
> installer all the files disappear.
> Anyone out there had any success a doing this with Express?
>