Upgrading SQL 2005 Express to full SQL 2005

Upgrading SQL 2005 Express to full SQL 2005

Post by bl9sbG95Z » Fri, 09 Feb 2007 09:15:01


I am trying to upgrade from SQL 2005 Express to full SQL 2005 using the
command line option. Also, install a new full SQL 2005 using the command line.

I am using the same command line parameters, to install a new full SQL 2005,
that I use to successfully install a new SQL 2005 Express, without success.


According to Microsoft they both should accept the same command line
parameters.


I have a script to validate a genuine Microsoft SQL 2005 setup.exe and then
pass the command line. I can successfully upgrade from SQL 2005 Express to
SQL 2005 Standard edition via my command line bootstrap. I have also proven
that I can install the SQL 2005 Express SP2 in the same manner but cannot
upgrade to full SQL 2005 using the command line option that was proven to
work with SQL 2005 Express. (no service pack)

I believe that full SQL 2005 cannot upgrade SQL 2005 Express service pack 2
as the service pack is newer.


Microsoft claim the sa can be passed to the full SQL 2005 setup.exe (as I
have done with the SQL 2005 Express successfully) but I feel this is the
where it is failing.


It is possible to use the GUI to input the same parameters (type in the sa)
and this works but we do not want to expose the sa password.

Example:

/qn ADDLOCAL=SQL_Engine SECURITYMODE=SQL INSTANCENAME=MYINSTANCE

SQLBROWSERAUTOSTART=1 SAPWD=%sa% DISABLENETWORKPROTOCOLS=0

1. Can the full SQL 2005 accept the sa via the command line as we have
successfully done with the SQL 2005 Express?

2. How do you upgrade SQL 2005 Express SP2 to full SQL 2005? Where is
the media, its not in our current MSDN kit?

3. Is it possible to upgrade or perform a new installation via the command
line using the 'sa' password only (no windows authentication).

Can anyone provide assistance please?
 
 
 

Upgrading SQL 2005 Express to full SQL 2005

Post by Uri Diman » Fri, 09 Feb 2007 16:32:23

Please do not multi post ,I have already answered in .programming group