SQL Server Security

From: Shaqman (shaqman_at_abc.net)
Date: 01/26/05

  • Next message: Dejan Sarka: "Re: Who deleted my records?" 
    Date: Tue, 25 Jan 2005 19:21:45 -0800

    New to SQL Server. I need to setup security where our network admin is
    different from SQL admin (DBA). Is there any recommendations as to how this
    needs to be setup (white paper or online publications). Basically my goal is
    to

    1. have a "locked" down sql server where only the SA account should manage
    the services
    2. Network administrators should not be able to use another EM to browse any
    data services
    3. SQL server and agent should start with the local account

    I am running Win2003 server with SQL Enterprise. Any help will be
    appreciated

  • Next message: Dejan Sarka: "Re: Who deleted my records?"

    Relevant Pages

    • using logins
      ... is how i should setup security without creating ... too many sql server logins. ... This mailbox protected from junk email by MailFrontier Desktop ...
      (microsoft.public.sqlserver.security)
    • Re: ODBC Security
      ... If SQL server then you can use windows integrated or sql server logons, if Access then you setup security in the access database, etc. etc. ... Dave Patrick ....Please no email replies - reply in newsgroup. ...
      (microsoft.public.windows.server.general)
    • RE: SQL Server Security
      ... SQL Server 2000 Security & Best Practices: ... Sample lockdown scripts that can be used to secure your SQL server: ...
      (microsoft.public.sqlserver.security)