What is the best way to implement intranet security in SQL2000 with integrated security


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: What is the best way to implement intranet security in SQL2000 with integrated security

  1. #1
    Lawrence Lau Guest

    What is the best way to implement intranet security in SQL2000 with integrated security


    We try to use integrated security in a 2000 environment. The problem that
    we have is SQL don't have a good way to query NT Groups/users unless we switch
    to Active Directory which will be years away for the company. We hack into
    the system stored procedure to find an undocument way to get NT Group which
    works in 7 but fail to work in 2000. Now, we found a work around using xp_logininfo.
    Although it is not perfect but it works. I wonder is there any better way
    to do Intranet with integrated security. I could not found anything on MSDN
    site.


    Thanks.
    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: What is the best way to implement intranet security in SQL2000 with integrated security

    What is it that you want to know? What NT groups an NT based user is in?
    What users are in a given NT group? I'm not clear on exactly what you're
    after....


    --
    Rob Vieira
    Visit www.ProfessionalSQL.com Today. It's new and improved!

    "Lawrence Lau" <llau@primeRestaurants.com> wrote in message
    news:3a6da15d@news.devx.com...
    >
    > We try to use integrated security in a 2000 environment. The problem that
    > we have is SQL don't have a good way to query NT Groups/users unless we

    switch
    > to Active Directory which will be years away for the company. We hack into
    > the system stored procedure to find an undocument way to get NT Group

    which
    > works in 7 but fail to work in 2000. Now, we found a work around using

    xp_logininfo.
    > Although it is not perfect but it works. I wonder is there any better way
    > to do Intranet with integrated security. I could not found anything on

    MSDN
    > site.
    >
    >
    > Thanks.



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center