Re: Users

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 23:02:09 +0530

Hi,

For Login creation SQL serevr uses the system procedure sp_addlogin, which
automatically picks MASTER database as default if the
default db is not specified.

No one knows the sa password, how do I find out what it is and can I change
it without causing any problems

Login to OS using a admin user and connect to SQL server in trunsted mode
and execute below command to change sa password

sp_password null,'newpassword',sa

This will change the password of sa to newpassword.

There is also a Builtin\Administrators user that has a type of "Windows
Group" how do I change that password or restrict access through it.

You can restrict the access of BUILDIN administrators but you need to take
care of the SQl Agent service and FULL TEXT indexing.
Change the passwords for the users which falls under the local admin group
in OS level.

Thanks
Hari
MCDBA

"Niles" <Niles@discussions.microsoft.com> wrote in message
news:703ADFCB-E4F1-4FF3-A902-BF7367DBE336@microsoft.com...
> When a new user is created, sometimes it defaults to a DB that I did not
specifically pick and it is not master. How is the default DB picked.
> Also,
> No one knows the sa password, how do I find out what it is and can I
change it without causing any problems.
> There is also a Builtin\Administrators user that has a type of "Windows
Group" how do I change that password or restrict access through it.
>
> Thanks

Relevant Pages