security/login problems

From: Alex (anonymous_at_discussions.microsoft.com)
Date: 11/26/03

  • Next message: Sue Hoegemeier: "Re: xp_cmdshell - Error 997 from GetProxyAccount on line 604" 
    Date: Wed, 26 Nov 2003 07:39:41 -0800

    What should I do to fix it?

    There is a story:

    I cannot signin to the new QA db with any existing id
    other than ALEX. When I try I get this message "Cannot
    open database requested in login ' QA '. Login fails.
    Please contact system administrator."
    And I can't create any new user ids - I get this
    message "User does not have permission to perform this
    action" though I'm using my ALEX id, and this message is
    followed by a db error. The id gets created, but when I
    try to signin with it I get this message "Logon failed
    for user .... Please contact system administrator."

  • Next message: Sue Hoegemeier: "Re: xp_cmdshell - Error 997 from GetProxyAccount on line 604"