PDA

View Full Version : Install MsSql 2005 Express from command line



NewsArchive
11-27-2009, 06:51 AM
Hi all,
I made an installer to allow the user to download the MsSql 2005 Express
installer and (trying) run it automátically.
The installer download the installer, ask for Instance name, user (sa) and
password and, with that info, runs the installer command line.
I read all the M$ info and I cant make it work, I´m trying to run it from
the command line (without SB) to test it like:

c:\users\alberto\downloads\SQLEXPR_ESN.exe /qb INSTANCENAME=sqlexpress05
SECURITYMODE=SQL SAPWD=wsami1962

It does not work.
Anyone has a command line that is running?
Thanks a lot
Alberto

NewsArchive
11-27-2009, 06:52 AM
Hi Alberto

Have you downloaded the SQL Express 2005 installation from SB?

Run SB as Administrator, Help, Redistribution Manager, then download the
2005 version and have a look at teh install script in there.

Cheers

Richard

NewsArchive
11-27-2009, 06:52 AM
Thanks, that worked but...
My system needs to login with sql mode, then I add the
SECURITYMODE=SQL SAPWD=sapass
to the commend line, all runs ok but...
sa appears as "login disabled"
and I cannot enable it
I´ve tried to use Mangement Studio and I cant enable it.
How can I solve it?
Thanks
Alberto

NewsArchive
11-27-2009, 06:52 AM
My fault!
All is ok now
Thanks