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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 installing SQL server 2000 - dummy friendly
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sqlinfant
Starting Member

3 Posts

Posted - 09/14/2012 :  13:35:09  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 09/16/2012 :  01:17:09  Show Profile  Visit jackv's Homepage  Reply with Quote
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 - 09/16/2012 :  02:34:50  Show Profile  Reply with Quote

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
Flowing Fount of Yak Knowledge

United Kingdom
2179 Posts

Posted - 09/16/2012 :  10:03:41  Show Profile  Visit jackv's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000