Re: SQL Server Authentication

From: Dan Guzman (danguzman_at_nospam-earthlink.net)
Date: 01/28/04


Date: Wed, 28 Jan 2004 07:57:51 -0600


> Any document talking about that. Due to our system auditor want get some
> supporting document talking about that.

Windows authentication is recommended in a number of places. From the SQL
2000 Books Online:

<Excerpt href="instsql.chm::/in_runsetup_6p9v.htm">

Security Note When possible, use Windows Authentication.

</Excerpt>

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Johnson Ng" <johnsonng@net-yan.com> wrote in message
news:%23hhdpTZ5DHA.1368@TK2MSFTNGP10.phx.gbl...
> Any document talking about that. Due to our system auditor want get some
> supporting document talking about that.
>
>
> "Dejan Sarka" <dejan_please_reply_to_newsgroups.sarka@avtenta.si> wrote in
> message news:Oy5M4sY5DHA.3896@TK2MSFTNGP11.phx.gbl...
> > > Any setting can fix the SQL user password length??
> >
> > Unfortunately in SQL Server there is no password or account policy like
in
> > Windows. That's why it is recommended to use Windows integrated security
> > whenever possible.
> >
> > -- 
> > Dejan Sarka, SQL Server MVP
> > Associate Mentor
> > Solid Quality Learning
> > More than just Training
> > www.SolidQualityLearning.com
> >
> >
>
>


Relevant Pages

  • Re: Credentials not being passed with remote access
    ... allowed windows authentication to work, ... I had assumed johnx was a domain user rather than a local Windows account. ... johnx was set up as a local login on sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: asp.net sql trusted connections between machines
    ... > connect to a remote SQL Server instance w/ Read-Write permissions. ... > connection string in the web.config. ... > Windows Authentication setting for access via IIS doesn't seem pass the ... is this impersonation behavior with IIS and Windows Authentication ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Very basic login question
    ... In order to use Windows Authentication the two computers have to be members of the same domain or trusted domains. ... you should have a login at the SQL Server on the XP Pro workstation. ...
    (microsoft.public.sqlserver.security)
  • Re: How to install and configure SQL Server 2005 on Net work and s
    ... database to backend and then link all table from front Access database to ... we never allowed user can login to sql server to do any thing, ... Each user they required Windows Authentication when they open they won ... install the sql server. ...
    (microsoft.public.sqlserver.security)
  • Re: MS SQL Server Management Studio Express - Changing User at Windows Authentication
    ... if i have 2 Computers in different domains (one with a SQL Server) and want to connect to the SQL Server with Windows authentication how can i change the login information in the "Connect to server" dialog. ... wenn ich 2 Computer in unterschiedlichen Domänen habe und mich mit diesen vom andren aus per Management Studio Express verbinden will kann ich bei der Windows Authentifizierung den Usernamen und das Passwort nicht ändern. ...
    (microsoft.public.de.german.entwickler.dotnet.datenbank)