Re: Users
From: Niles (Niles_at_discussions.microsoft.com)
Date: 07/06/04
- Next message: Narayana Vyas Kondreddi: "Re: How to import excel data to tempdb"
- Previous message: John Bell: "Re: sp3a upgrade to developer edition"
- In reply to: Hari Prasad: "Re: Users"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Jul 2004 12:11:01 -0700
Hari,
To change sa login do I connect via an ODBC connection - and is an account with local admin on my machine would accomplish that change. Also is there anything that may be affected with that change?
now the Builtin\administrators user has a System Administrtors role (in SQL) and database access to all dbs. Can I uncheck that role or is that a default access.
What type of access would you allow network engineers to have in sql, the main functionality is a network back up they run and include SQL in that.
Where can I get mor info on Buildin account and what effect it has on SQL Agent Service and Full text indexing? I couldn't find info on this account at BOL
Where can I find a list of stored procedures (like the one you mentioned below for changing the sa password) and a description of what they do?
Thanks in advance
"Hari Prasad" wrote:
> 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
>
>
>
- Next message: Narayana Vyas Kondreddi: "Re: How to import excel data to tempdb"
- Previous message: John Bell: "Re: sp3a upgrade to developer edition"
- In reply to: Hari Prasad: "Re: Users"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
