What is the best practices are supposed to be for MS SQL authentication?

From: Hubco (Tareq.Yasiji_at_hudsonunitedbank.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 08:11:09 -0800

Hi There;
I have few SQl 2000 server in my site and I was wondering about SQL security and I like to know:
What is the best practices are supposed to be for MS SQL authentication? Is it NT/2000 Authentication or SQL, and is there a way to encrypt the authnication and make sure that is not save on Server or Worksation as clear text. Please let me know.

Thank you.

Relevant Pages

  • Re: Failed to connect to SQL express on LAN
    ... Although I wrote that SQL Authentication worked with the sa account, ... I went on the DELL8300 server and tried to enable nore server roles for the ... For SQL Authentication, from your test, I think that SQL Authentication was ...
    (microsoft.public.sqlserver.connect)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
Loading