Professional Web Applications Themes

SQL server access from asp.net via ads-group-member - ASP.NET Security

Hi, in our intranet we have an active-directory with two groups. one called reading and the other one writing. we use windows-authentication to know who is comming in. we get the REMOTE_USER-Name, lookup ads and get the real name and the group the user is in. up to now we choose which connection string and user to sql-server to use (read or write) because of the group name from ads. so far so good, but we want to know who is currently using the database. we only get our two different read or write-connections but no specific user. how do ...

Sponsored Links
  1. #1

    Default SQL server access from asp.net via ads-group-member

    Hi,

    in our intranet we have an active-directory with two groups. one called
    reading and the other one writing. we use windows-authentication to
    know who is comming in. we get the REMOTE_USER-Name, lookup ads and get
    the real name and the group the user is in.
    up to now we choose which connection string and user to sql-server to
    use (read or write) because of the group name from ads.

    so far so good, but we want to know who is currently using the
    database. we only get our two different read or write-connections but
    no specific user.

    how do we see who is currently working on the database? it won't make
    sense to put all user into sql-server and use a connection for each
    user?
    any help would be greatful.

    Michael

    Sponsored Links
    Michael Guest

  2. #2

    Default Re: SQL server access from asp.net via ads-group-member

    You could just use a trusted connection type of connection string, along
    with impersonation, and use Windows security in SQL directly.

    However, to get this working, you'll likely need to get Kerberos delegation
    working as well.

    Joe K.

    --
    Joe Kaplan-MS MVP Directory Services Programming
    Co-author of "The .NET Developer's Guide to Directory Services Programming"
    http://www.directoryprogramming.net
    --
    "Michael" <de> wrote in message
    news:googlegroups.com... 


    Joe Guest

  3. #3

    Default Re: SQL server access from asp.net via ads-group-member

    Thanks Joe,

    i'll check this out.

    Michael

    Michael Guest

Similar Threads

  1. List AD-Group Member AND WHOSE TRUSTED DOMAIN with WinNT
    By Thauhtopa in forum ASP.NET Security
    Replies: 1
    Last Post: December 7th, 03:29 PM
  2. List of member for a group
    By Marin Marinov in forum Windows Server
    Replies: 2
    Last Post: June 9th, 06:00 PM
  3. how to add user group member
    By Kristianto in forum Sun Solaris
    Replies: 1
    Last Post: June 26th, 11:26 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139