Re: Domain or Workgroup

As far as SQL Server 2000 is concerned, Domain users are the way to go.
Windows authentication provides better security, better password control,
less 'user' maintenance for the DBA, etc..

It really is a 'no-brainer'.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"Mernick" <Mernick@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7A762C88-472D-4094-B560-14C5D6C972D3@xxxxxxxxxxxxxxxx
We recently moved our main application from a work group environment, to a
server environment.

What are the trade offs in having our users becoming part of our new
domain
or to remain in their work group and access SQL Server through Server
Authentication?

Hope to hear from you soon

Robert Mernick




.

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)
  • ASP + SQL 2000 + Win2k SP4
    ... SQL Server connection. ... OS is Windows 2000 and SP4 on both the IIS server and SQL server, ... enable Integrated windows authentication. ... There is a role for domain users to use giving them execute permissions ...
    (microsoft.public.sqlserver.odbc)
  • 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)