managing msde with nt authentication

From: Ed Johnson (nospam_at_nospam.com)
Date: 09/24/04

  • Next message: Dan Guzman: "Re: managing msde with nt authentication" 
    Date: Thu, 23 Sep 2004 20:29:53 -0700

    I have my program running right now on sqlserver authentication because it
    was easy to maintain and seemed to get around the need for managing user
    rights in a domain. But I wanted to know the practical steps of how to
    change my application to use nt authentication. Do I have to be on a domain
    to use nt authentication? I know that you can't use NT authentication on
    Win9x OSes. If my clients are running on Windows NT derivatives and they are
    all running local MSDE databases on their on computers, how do I manage
    their logons using NT integrated security? Do I have to add them to the
    sqlserver user database? It seems like when I used a logon with admin rights
    I did not have to do that, but when a customer logged on with only power
    user rights in the domain that they could not use nt authentication - is
    that because I did not have their name in the mssql server database user
    list? How do I maintain security for MSDE on a local instance using NT
    authentication? Thanks for any advice?

    From: Ed

  • Next message: Dan Guzman: "Re: managing msde with nt authentication"

    Relevant Pages