Re: SQL Login

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 08/28/03 

Date: Thu, 28 Aug 2003 14:25:27 +0200

After installation, members of the local Administrators group are mapped to
the sysadmin role. The sa login account is a member of that role as well.
Afterwards, do please refer to the mentioned topic in Books OnLine. 

-- 
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Sanka" <loonysan@mailcity.com> wrote in message
news:0c1001c36d4d$b0435d20$a301280a@phx.gbl...
> Hi,
>
> But how do we add the User X to the sysadmin /
> securityadmin role first.
>
> Does the User X need to depend on the "SA" password or
> some other sysadmin / securityadmin personnel for that.
>
> Regards,
> Sankaranarayanan M G
>
> >-----Original Message-----
> >To add a login, a user must be a member of the sysadmin
> or securityadmin
> >fixed server role. So, if the Windws account is a member
> of some of those
> >two roles, a user can add a login, otherwise not. Check
> the "Adding a Member
> >to a Predefined Role" topic in Books OnLine
> >(mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%
> 20Server\80\Tools\Books\ad
> >minsql.chm::/ad_security_6ndx.htm).
> >
> >-- 
> >Dejan Sarka, SQL Server MVP
> >FAQ from Neil & others at: http://www.sqlserverfaq.com
> >Please reply only to the newsgroups.
> >PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >"Sanka" <loonysan@mailcity.com> wrote in message
> >news:08ef01c36d36$80718250$a401280a@phx.gbl...
> >> Hi,
> >>
> >> User X is a machine administartor in the SQL Server box.
> >> By Default, when User X logs in the machine, he is not
> >> able to access any of the DTS packages / access tables
> >> present in the Databases.
> >>
> >> Guess the User X ID has to be added in the SQL Server as
> >> well. Is it possible for User X to login in the machine
> >> and add himself as the Administrator of the SQL Server
> >> without knowing the "SA" Password or with no help from
> the
> >> other SQL Server Administrators.
> >>
> >> Regards,
> >> Sanka

Relevant Pages

  • Re: cannot acees two databases as owner
    ... it does not matter you are a member of the ... the sysadmin fixed server role or if there is no any other Login which is ... group if it's a domain) and you can login to your SQL Server with, ...
    (microsoft.public.sqlserver.setup)
  • Re: how to find out if a domain user is in the sysadmin server role?
    ... I connected with a login that is a member of a group that is a sysadmin. ... print 'Current user''s login is NOT a member of the sysadmin role' ...
    (microsoft.public.sqlserver.security)
  • Re: cannot acees two databases as owner
    ... member of the built-in group Administrators, is not sysadmin. ... Administrator of SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • Re: Other way of Changing Password if does not have Server Role
    ... A user can change his password without being a member of the sysadmin role. ... You just have to login as the user and then omit the 3rd parameter ... Dejan Sarka, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2005 Express setup
    ... Because SQL Server would create a Login for Local Administrators and add this Login to the System Administrator "sysadmin" role. ... However, if you want your Login to be a System Administrator, then you should log in to your SQL Server Instance as a System Administrator and add your own Login to the sysadmin Fixed Server Role. ...
    (microsoft.public.sqlserver.setup)