Best practise for SQL Server 2000 Security

From: Jos (josnospambranders_at_fastmail.fm)
Date: 09/25/04

  • Next message: Greg D. Moore \(Strider\): "Re: Database Memory" 
    Date: Sat, 25 Sep 2004 11:03:54 +0200

    Who can give me a simple checklist to follow (best practices for security)
    when
    1) Setting up a SQL Server
    2) Setting up a new database

    I mean: right after installing a server or a database,
    do you systematically take additional security measures?

    I'm using books to teach myself about SQL Server, but these
    best practices are something you rarely find in books.
    I found a list here:
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec04.mspx
    but I really would like to hear from you, what you do in
    "every day" SQL Server administration.

    Thanks in advance, 

    -- 
Jos
  • Next message: Greg D. Moore \(Strider\): "Re: Database Memory"

    Relevant Pages

    • Re: SQL or Access DB
      ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Cryptography in SQL Server 2000
      ... SQL Server 2000 Out-of-the-Box database security solution. ... database protection and privacy software is an industry-proven ...
      (microsoft.public.sqlserver.security)
    • Re: SQL or Access DB
      ... i am aware of the security modell of SQL server (we do use SQL server ... an end user,,, there is not reall alternative as a worgroup Access database ... MSDE and SQL express are all free ...
      (microsoft.public.dotnet.languages.vb)
    • Re: Cryptography in SQL Server 2000
      ... A company is vulnerable when its security ... > database encryption solution with protected key-management software ... > tested by the SQL Server Test Lab. ...
      (microsoft.public.sqlserver.security)
    • Re: Trusted connections??
      ... implement role or user based security at the SQL Server. ... If the ASP.Net app controls what the user can request of the database then I ... I implement user authentication at the application and the application ...
      (microsoft.public.dotnet.framework.aspnet)