Post reply

Windows authentication : user still works but no login

  • December 16, 2011 at 1:49 pm

    #247830

    A windows authenticated user is presnt in a database .Its associated login is not presnt under logins. Application is still able to access with that user. How can this be?

  • December 16, 2011 at 2:00 pm

    #1422720

    that's normal, because you most likely have a group the user belongs to as a login into the database; it might even be an admin group.

    try either ofg these two procs to help wiht the investigation.:

    EXEC master..xp_logininfo

    @acctname = 'mydomain\lowell',

    @option = 'all' -- Show all paths a user gets his auth from

    go

    EXEC master..xp_logininfo

    @acctname = 'mydomain\authenticatedusers',

    @option = 'members' -- show group members

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 16, 2011 at 2:23 pm

    #1422733

    thanks...that helped.i was looking for this xp...

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply