SQL Server Forums
Profile | Register | 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
 New Topic  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
2079 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
2079 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  
 New 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.05 seconds. Powered By: Snitz Forums 2000