Upgrade fails: SQL Server Express 2005 to SQL Server 2005

Upgrade fails: SQL Server Express 2005 to SQL Server 2005

Post by TmlrbGFzIE » Thu, 12 Jun 2008 00:56:03


Hi,
I have installed SQL Server Express 2005 on my Windows Small Business Server
2003 R2 Premium. But I then afterwards noticed that there were two discs
included with SQL Server 2005 that has no limits in the database sizes as the
Express version have (4GB MAX). So I wanted to install the better version,
but the setup ends with a warning saying I should run the setup of SQL Server
2005 using command lines with the switch SKUUPGRADE=1.

So I inserted the CD that was included with the R2 Premium Edition.


start /wait D:\SQL2005\setup.exe SKUUPGRADE=1 /qb

The installation didn't prompt for anything this time, it just ended without
any confirmation. I started up "SQL Server Management Studio Express" and it
said the following services was "Running": SQL Server (MSSQLSERVER). The
instance name had changed from (SQLEXPRESS) to (MSSQLSERVER). But I went to
properties for the service and it still says "Express Edition". So how do I
manage to install the better version that was included with my package of Win
SBS 2003 R2 Premium Edition?
 
 
 

Upgrade fails: SQL Server Express 2005 to SQL Server 2005

Post by Costa » Thu, 12 Jun 2008 01:55:12

The first thing you can do is check to see if the database was upgraded. In
Management Studio, right click on the database and select 'Properties'.
Then click on 'View Connection Properties' and check the value next to
'Product Name'. If it says Express, then the database wasn't upgraded.

Your best bet will be to uninstall SQL Server 2005 Express and install the
Workgroup Edition that came with SBS. That assumes you make backups of your
current databases.

--
Costas

 
 
 

Upgrade fails: SQL Server Express 2005 to SQL Server 2005

Post by TmlrbGFzIE » Thu, 12 Jun 2008 21:22:01

I did check the properties in Management Studio, it says "Express Edition".
I did try to uninstall SQL Server Express 2005, but then when trying to
install the workgroup edition it failed with an error saying I allready have
a version of SQL Server Express installed. Any other suggestion?

I lack knowledge of backup databases, is this something I will want to do? I
have nothing that have intentionally put in a databse yet. But if the SBS
server has put something in a database from an installation, I may want to
backup that?! - Please advice.

Thanks