DIGIT-ARC read-only archive · snapshot: July 23, 2026

Installing prob of MS SQL Server 2000 (dev edition)

8 posts · originally from https://geek.digit.in/community/threads/installing-prob-of-ms-sql-server-2000-dev-edition.32828/

ashu888ashu888
ashu888ashu888 Original post #1
Jul 28, 2006 at 10:57 AM
Hey guys,

I am facing sum annoying problems while installation and running of MS SQL SERVER 2000 Developer Edition.

I got the CD from my NIIT institute (so its not pirated) and now, i wanna install the s/ware so tat i can practice the SQL database functions including the programming part, i e: T (transact) SQL.

I selected the Server & Client Tools from the options of: Client tools, Server & Client tools and Connectivity tools.

But after the installation wen i clik on the Querry Analyzer, i get these errors (as shown below).

*images1.pictiger.com/thumbs/a8/8d66c3981a9beeb378bd1701b2d65aa8.th.jpg
*images1.pictiger.com/thumbs/ee/7e290c07d68e417afa74ada74ce3a0ee.th.jpg
Upload Pictures with PicTiger

So please tell me wat wrong am i doin ???


Cheers n e-peace....
DukeNukem
Jul 28, 2006 at 11:08 AM
(i cant open the picture link) but the icon pic shows you are not entering the username and password

choose the server name or put "." without " there
enter as sa and the password if you have choosed at the time of installation
ashu888ashu888
Jul 28, 2006 at 12:29 PM
@ Duke

But, during installation i did not specify any paswrd or username. And from the login screen, i guess the login name is just sa but wat to do ?? I cannot enter into it ?? Please suggest...


Cheers n e-peace....

Here are the screenies (acreenshots) that i get and the options tat i choosed during the installation of SQL SERVER 2000.

Please advice me and tell me where im wrong.As even by selecting these options, i cannot run SQL and i get the errors. (as posted by the screenshots in the first post of this thread.)

*images1.pictiger.com/thumbs/a5/098bc28b60eab7da512a7a9cc4104ea5.th.jpg

*images1.pictiger.com/thumbs/80/d5b42e4623f1852b2e35739bf7a4fd80.th.jpg

*images1.pictiger.com/thumbs/27/f77802ef69eba886de6fb8a5d09e7927.th.jpg

*images1.pictiger.com/thumbs/25/2e141609d5b21cc0f8108d702bb4da25.th.jpg
ashu888ashu888
Jul 28, 2006 at 12:50 PM
And sum more...

*images1.pictiger.com/thumbs/14/1524d9fc00a4ec530538cbf1c614b214.th.jpg

*images1.pictiger.com/thumbs/fc/c6030385d9d7ae28c28923ce66be91fc.th.jpg

*images1.pictiger.com/thumbs/06/c3ed242f27643d46a3546651a59e6406.th.jpg

*images1.pictiger.com/thumbs/f0/6eb9f756d2cbfe9ad629f0ee0db08af0.th.jpg

Please guide me as i hv given all the details of my problem...

Cheers n e-peace...
royal
royal #5
Jul 28, 2006 at 1:02 PM
since you have used Windows Authentication during install , you have to select the SqlServer from the DropDown box and check "Start Sql Server if it is stopped"
DukeNukem
Jul 28, 2006 at 4:25 PM
in this case as suggested start the server from the taskbar (ofcourse)
then fire query processor
enter the user name and the password of your windows account
if this wont help
then reinstall the server and now this time choose the mixed mode login type
hope fully( every thing crossed) that would help







--------------------------------------------------------------------
rest in pieces
ashu888ashu888
Jul 28, 2006 at 5:45 PM
@ Duke, Royal

Thanx for ur replies guys, Well wat u guys wrote didnt help me much but i (by mistake and in reluctance) checked the Windows Authenticaton in the "Connect Using" option and it worked, i was able to launch my SQL server. Thanx for ur replies too guys.. :)

BTW, now i have sum dat files (contained in a script folder conatining sum DOS like screens and txt files) tat i had brought from my NIIT institute and i wanna upload this set database into the SQL so please tell me wat and how to go abt it..

Awating replies...


Cheers n e-peace....

Come on help me out guys with installing my database.. : (

Cheers n e-peace....
ashu888ashu888
Aug 4, 2006 at 8:40 PM
********Problem Solved *********

I was able to install the databases into the SQL server by just opening the querries (from the SQL window) and executing them (by pressing F5)...

Just a useful info for other ppl who might find it helpful... : )

Cheers n e-peace....