Help with installation of SQL Server 2000 SP4

Hi,

I was wondering if anyone might be able to help me here. To be honest, this is my first time i have encountered SQL Server 2000 SP4. I need some guidance as to how to install and set up the SQL Server 2000 SP4. I have done it with SQL Server 2005 Express Edition and it's (I think) a lot easier to install and get it going.

My computer runs on windows XP Pro (windows 32bit). I got confused when i got to the following microsoft webpage - http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-99a9-b7f0213f8bc5&DisplayLang=en. I downloaded SQL2000-KB884525-SP4-x86-ENU.EXE. And when running the setup.bat, the message came up saying "SQL Server 2000 is not installed on this machine. setup will now exit". What do i need to have the SQL Server 2000 installed on my machine?

Thank you in advance

What you tried to download is just the service pack, if you want to use SQL Server 2000 you either have to buy an edition (the developer edition is quite cheap) or get the MSDE which is the equivalent to the SQL Server Express Edition. MSDE was not bundled with the service pack like Express is, so you first have to install the SQL Server MSDE and then afterwards the SP4. Hope thing are clearer now.

HTH; Jens Suessmeyer.

http://www.sqlserver2005.de|||

Hi Jens,

Thank you for your support.

I've downloaded MSDE2000A.exe package. I run the setup.exe by typing in the command line as follows

setup SAPWD=hello INSTANCENAME="InstanceName" TARGETDIR="C:\MyInstanceFolder"

setup /settings "MyParameters.ini" SAPWD=hello

I've got an error message saying "The instance name specified is invalid".

I thought i have specified it to be InstanceName.

Can you help please?

Thank you in advance

|||

Where are you getting the error information, at the first commandline call, or the second. If it is the second, send the ini file over.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de