never made 'sa' password in sql 2000

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

General SQL Server Forums

New to SQL Server Administration

never made 'sa' password in sql 2000

Author

Topic

mcgruff
Starting Member

4 Posts

Posted - 2013-12-02 : 23:33:01

i installed sql server 2000 because another program (MV Engineering assistant powered by AMS 6.1 )needs it to run, now during the install i receive a msg saying "SQL server exists on this PC enter the SQL server password for the 'sa' administrator account" but i was not prompted to make any sa password and do not know what it is. it is stopping me from installing a application i need for work and i need this solved, i have to use sql server 2000 and it needs sql 2000 service pack 3 specifically and i am running windows xp service pack 1

when the password is left blank it says
the SQL server password entered for the "sa" administrator account is incorrect.
Check to make sure that the SQL server is set up for mixed mode authentication.

this is what the Manuel for program i am installing says regarding the sa password, i simply dont know enugh about sql to figure it out.

• If SQL Server 2000 SP3 is already installed, the AMS installation program will
continue with the next part of the installation program. (Access to the SQL
Server ‘sa’ account is required. If you don’t have access, contact your network
administrator for more information.)

A Microsoft SQL Server 'sa' account password is not required for AMS operation.
Therefore, the AMS 6.1 setup does not create an 'sa' password. However, for
security reasons, it is recommended that you configure your SQL Server to
require a password. After installing AMS, determine if your SQL Server should be
password-protected (if you are unsure, ask your network administrator). If you find
that your SQL Server application is password-protected, no further steps are
necessary.

mcgruff
Starting Member

4 Posts

Posted - 2013-12-02 : 23:40:02

also i am extremly new to sql and the forum, I want to Hello to all and i apoligise that i am a noob and my first post is question. I am looking forward to learning about sql with you all

mcgruff
Starting Member

4 Posts

Posted - 2013-12-03 : 00:05:35

also i dont seem to have Management Studio installed and cant seem to find it for 2000

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-12-03 : 06:41:44

quote:
Originally posted by mcgruff

also i dont seem to have Management Studio installed and cant seem to find it for 2000

SQL 2000 installation doeant come with management studio. Its client tools include query analyser for running queries and Enterprise Manager for registering server instances and do activities through GUI

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2013-12-03 : 13:23:09

It sounds like the SQL Server install was not done with mixed mode - so you only have Windows Authentication enabled. To fix that, you will need to locate Enterprise Manager and see if you can access the instance. If you can do that, then switch the authentication method on the Server Properties, set the sa account password and restart SQL Server.

You should then be able to continue with your installation.

mcgruff
Starting Member

4 Posts

Posted - 2013-12-03 : 21:05:36

thank you, i cant seem to find enterprise manager on the computer and it did not appear to install with sql2000 desktop edition when i installed it. I tried to install the one from 2008 but it did not work

quote:
Originally posted by jeffw8713

It sounds like the SQL Server install was not done with mixed mode - so you only have Windows Authentication enabled. To fix that, you will need to locate Enterprise Manager and see if you can access the instance. If you can do that, then switch the authentication method on the Server Properties, set the sa account password and restart SQL Server.

You should then be able to continue with your installation.

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2013-12-04 : 14:56:11

If I recall correctly - the desktop edition does not come with Enterprise Manager. You would have to download that separately - if you can even find it.

If you download the SQL Server 2005 Management Studio Express you should be able to use that.

Now, with all of that said - I would recommend that you try SQL Server 2005 Express instead of 2000. When you build out the system, you can set the compatibility level of the database to 80 (2000) and it should work. No guarantees, of course...

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2013-12-04 : 15:21:52

quote:
Originally posted by jeffw8713

If I recall correctly - the desktop edition does not come with Enterprise Manager. You would have to download that separately - if you can even find it.

MSDE didn't even have a downloadable GUI, from Microsoft at least. There are probably open source/free solutions out there.

I once had to work on an MSDE server and could not get a GUI to connect to it. I was stuck writing commands in osql.exe. I am a command-type person, but geez there's so much you have to lookup.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2013-12-05 : 19:09:39

If the issue is that you need to enter Mixed Mode, here is a link on how to manually configure this via the registry:
http://support.microsoft.com/kb/322336

HTH

=================================================
No, no, you're not thinking, you're just being logical. -Niels Bohr

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources