Desktop Edition Sql server 2000 MSDE Install upgrade

for sql server 2000 (I know its old) desktop edition does not includes any GUI. so installation of desktop edition ie MSDE is via command prompt.

you can install the setup for desktop edition for free from here.

http://www.microsoft.com/download/en/details.aspx?id=22661

to install, just download the exe. and extract it.

setup.exe /settings C:\MSDERelA\setup.ini /L*v C:\MSDERelA\MSDE_setup.log

it will install the sql server 2000 desktop edition.

select serverproperty(‘productversion’)

select serverproperty(‘Edition’)

select serverproperty(‘ProductLevel’)

Now to upgrade the SP4 install it from here.

http://www.microsoft.com/download/en/details.aspx?id=18290

setup /upgradesp sqlrun /L*v C:\MSDELog.log

ERRORS:

some time you may get an error

  1. Strong SA password required

For such errors include SAPWD=”xxx” for installation and upgradation.

Provide strong sa password.

  1. Invalid instance name


This error occurs when we do not include /upgradesp option in upgrade

This has been improved in sql server 2005 where we can install gui for desktop edition. And can upgrade.


Advertisements
This entry was posted in Add/remove, Installation, Limitation, Troubleshooting and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s