Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 installing SQL server 2000 - dummy friendly

Author  Topic 

sqlinfant
Starting Member

3 Posts

Posted - 2012-09-14 : 13:35:09
I was using SQL Server 2000 (query analyser, enterprise manager etc).The installation was done by the institute where I did a beginners course on Sql 2000. I was accessing data saved on my machine. Now the machine has developed some problems and all the data/software is lost. I need to get SQL 2000 installed on another machine - I do not have any installation CD or something. I did lookup microsoft site(download section) but the different versions, patches etc are beyond me. Can someone explain in simple english how I can get SQL 200O running again (or point to some link which explains the same ? )

Please help

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-16 : 01:17:09
A detailed guide from Micrsoft
http://support.microsoft.com/kb/303747

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

sqlinfant
Starting Member

3 Posts

Posted - 2012-09-16 : 02:34:50

As I mentioned i dont have an installation CD.
I downloaded "Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) Release A" from the website but getting stuck as it asks for " a strong password" and gives the error ' the names instance is invalid'

1)Is MSDE the right download for SQL Server 2000 ( Enterprise manager, Query Analyser etc)
2) What is the exact command for this strong password / instance name ? I have read through the readme file but unable to comprehend

Pls help





quote:
Originally posted by jackv

A detailed guide from Micrsoft
http://support.microsoft.com/kb/303747

Jack Vamvas
--------------------
http://www.sqlserver-dba.com

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-09-16 : 10:03:41
Scroll down to the bottom of the page and download sql2kdesksp3.exe
This is the SQL Server personal edition
http://www.microsoft.com/downloads/...&displaylang=en




Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -