SQL 2000 Security Question

From: Blake Mengotto (mengotto_at_nospam.hotmail.com)
Date: 05/28/05

  • Next message: Jono Price: "Change SQL Server Authentication method programmatically" 
    Date: Sat, 28 May 2005 01:20:56 -0700

    Simple question from someone who knows nothing about SQL.

    SQL is set to use Windows Authentication only.

    I deny access to Built-In\Administrators

    I add an account that is a local admin on the SQL box, and give it DB_Owner to various DB's that it should own, and be able to do whatever in.

    Will the DENY on Built-in\Admins keep this local admin id from accessing SQL?

    TIA 

    -- 
Regards,
Blake
  • Next message: Jono Price: "Change SQL Server Authentication method programmatically"

    Relevant Pages

    • RE: local admin account password
      ... Do you think if someone wanted to break the local admin account they ... more recovery console and don't think cached logins will work. ... 5)My main idea/plan is to store all the passwords on a central SQL server. ...
      (Focus-Microsoft)
    • Re: Users
      ... 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. ... 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. ...
      (microsoft.public.sqlserver.server)
    • Re: DTS fails on job but runs manually
      ... Basically the issue was that the sql account did not exist on my destination ... When executed by the SQL Agent your DTS package runs as the local admin ... making use of resources outside the machine where the SQL Server runs. ...
      (microsoft.public.sqlserver.dts)
    • Re: Installing SPS
      ... that SQL wants the user to be a local admin on the SQL box. ... > "Shane Young" wrote: ... >> I use 1 account for everything. ...
      (microsoft.public.sharepoint.portalserver)
    • Re: Security Question
      ... > to deny access? ... Dejan Sarka, SQL Server MVP ...
      (microsoft.public.sqlserver.setup)