Stuck with SA user - SQL Server Forums

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 Administration (2000)

Stuck with SA user

Author

Topic

kamalkishore_in
Yak Posting Veteran

76 Posts

Posted - 2002-09-19 : 04:37:49

Hi guys,

I am using SQL Server 2000. Till now I was using the default user called 'sa' without any password (default setting).

Now I have created new users.

Then I was thinking of removing SA user.
I have given a the command:

sp_droplogin @loginame = N'sa'
GO

Question 1 : How can I UNDO the above command
Question 2 : How to drop 'sa' user from a perticular database
Question 3 : How to change the password for the 'sa' user

thanks..
I am really stuck with this
help needed

rihardh
Constraint Violating Yak Guru

307 Posts

Posted - 2002-09-19 : 04:45:59

Hmmm...

Question1: Why should anyone have the need to "drop" the SA user?
Question2: Why is someone looking for the "undo" function when there really is no need for it?
Question3: Have you recently read BOL?

Andraax
Aged Yak Warrior

790 Posts

Posted - 2002-09-19 : 06:38:56

rihard you are a bit cynical I think... :)

The 'sa' login cannot be dropped by sp_droplogin. I suggest you change the password of the sa login to a long password (12+ chars) and include numbers in the password. You can change the password with this command:

sp_password @loginame='sa', @new='newpassword', @old='oldpassword'

If the user doesn't have a password to begin with just leave out the @old parameter.

/Andraax

kamalkishore_in
Yak Posting Veteran

76 Posts

Posted - 2002-09-19 : 21:48:36

Okey I got it,

But one more question...

Is it possible to make a sa password NULL ( I mean as it was at the time of installation) once you change sa password.

looking for answer

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-09-19 : 22:19:26

NO!!!!

You ABSOLUTELY NEVER want to have a blank password for SA. NEVER. Change it to another password if you must, but NEVER leave it blank or null.

There is more about it here:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=19638
http://news.com.com/2100-1001-919461.html?legacy=cnet&tag=pt.msn.cdf.hl.ne_9938072

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources