Re: DBA Permissions

From: BP Margolin (bpmargo_at_attglobal.net)
Date: 05/08/03

  • Next message: Tom Moreau: "Re: DBA Permissions" 
    Date: Thu, 8 May 2003 17:28:20 -0400

    George,

    If you don't have a Windows account, how do you start the SQL Server service when it isn't running. Please be specific as to the commands you issue.

    Keep in mind that without a Windows account, you can't log on to Windows itself to start the service, and since the SQL Server service is stopped, you can't connect to SQL Server.

    Perhaps there is a miscommunication between you and Tom. Tom is not asking whether you have an account within SQL Server that uses Windows Authentication. He's asking about how you connect to the Windows OS.

    -------------------------------------------
    BP Margolin
    Please reply only to the newsgroups.
    When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
    can be cut and pasted into Query Analyzer is appreciated.

    "George" <tech@hotmail.com> wrote in message news:062d01c3159f$b0ee3390$3001280a@phx.gbl...
    > I don't have a windows account, I have an sqlserver
    > account with sysadmin priviledges..
    >
    >
    >
    >
    > >-----Original Message-----
    > >Is your personal Windows account a member of the local
    > Administrators group?
    > >
    > >--
    > >Tom
    > >
    > >----------------------------------------------------------
    > -----
    > >Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    > >SQL Server MVP
    > >Columnist, SQL Server Professional
    > >Toronto, ON Canada tom@cips.ca
    > >www.pinnaclepublishing.com/sql
    > >
    > >
    > >"George" <gfentres@hotmail.com> wrote in message
    > news:011601c31599$01b0a800$a501280a@phx.gbl...
    > >SQL Server services running under a domain user account
    > >which is in the local administrators group and I am able
    > >to stop and restart SQL Server services through EM with
    > >sql server account that is sysadmin.
    > >
    > >
    > >
    > >>-----Original Message-----
    > >>You can shut down SQL Server using the T-SQL command
    > >SHUTDOWN but you cannot restart it, since SQL Server is
    > >not up and it needs to be up in order to determine that
    > >you are part of the sysadmin role. Starting and stopping
    > >services on a box is an administrator's job.
    > >>
    > >>--
    > >>Tom
    > >>
    > >>---------------------------------------------------------
    > -
    > >-----
    > >>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    > >>SQL Server MVP
    > >>Columnist, SQL Server Professional
    > >>Toronto, ON Canada tom@cips.ca
    > >>www.pinnaclepublishing.com/sql
    > >>
    > >>
    > >>"George" <gfentres@hotmail.com> wrote in message
    > >news:061d01c31596$50657550$2f01280a@phx.gbl...
    > >>Can't a SQL Server user with sysadmin priviledges be
    > able
    > >>to do that ?
    > >>
    > >>
    > >>>-----Original Message-----
    > >>>If you're not in an Active Directory, then the DBA
    > >should
    > >>also have the authority to stop and start SQL Server and
    > >>related processes. With AD, you can create a Group
    > >Policy
    > >>Object to narrow down the authority to just those
    > >>processes.
    > >>>
    > >>>--
    > >>>Tom
    > >>>
    > >>>--------------------------------------------------------
    > -
    > >-
    > >>-----
    > >>>Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
    > >>>SQL Server MVP
    > >>>Columnist, SQL Server Professional
    > >>>Toronto, ON Canada tom@cips.ca
    > >>>www.pinnaclepublishing.com/sql
    > >>>
    > >>>
    > >>>"George" <gfentres@hotmail.com> wrote in message
    > >>news:05a701c31594$b3c26330$3301280a@phx.gbl...
    > >>>Is there any other reason why a DBA should be in
    > >>>Administrators group of the local SQL Server computer
    > >>than
    > >>>Installing the software and related patches and SP's ?.
    > >>>
    > >>>Is there a documentation on this ?
    > >>>
    > >>>Thanks.
    > >>>
    > >>
    > >

  • Next message: Tom Moreau: "Re: DBA Permissions"

    Relevant Pages

    • Re: SQL Profiler wont allow a developer to login
      ... I would have one of them to login using their windows account, open a query window and verify whether they are sysadmin. ... Tibor Karaszi, SQL Server MVP ... I have a SQL Server that is causing some issues when devleopers attempt to ...
      (microsoft.public.sqlserver.tools)
    • Re: DBA Permissions
      ... Columnist, SQL Server Professional ... Keep in mind that without a Windows account, you can't log on to Windows itself to start the service, and since the SQL Server service is stopped, you can't connect to SQL Server. ... >>SQL Server MVP ...
      (microsoft.public.sqlserver.security)
    • Windows Authentication with IIS on separate machines
      ... -Web Application is using Basic Authentication set in IIS ... -Added user account TESTUSER and gave read access to ... in SQL server but doesn't work if user account was ... Windows account, ...
      (microsoft.public.sqlserver.security)
    • RE: Login Failed Reason: Token-based access failed
      ... I've noticed in SQL Server 2008 when a Windows account doesn't have a Login ... validation failed with an infrastructure error. ...
      (microsoft.public.sqlserver.server)
    • Re: Login failed for user (null). Reason: Not associated with a trus
      ... When you establish a trusted connection, SQL Server validates your identity using the Windows account the client is logged in as. ...
      (microsoft.public.sqlserver.security)
    Loading