Results 1 to 2 of 2

Thread: error 15007

  1. #1
    Join Date
    Feb 2003

    Unanswered: error 15007

    I am having some issues with authenticatio in that
    sql account exist although the account do not seem to have permission to log on to the server

    error 15007

    The sets of servers are in 3 domains with a complete trust model
    and teg message staes the login does not exist

    When i attempt to create the login a separate error states that the user name already exists

  2. #2
    Join Date
    Dec 2002
    A few more details would be nice in order to provide a complete answer. You say you have three domains and that trusts have been established among the domains. For the sake of argument, let's call the domains A, B and C. Let's also say that SQL Server is running on a server in domain A. Finally, let's say that you have two users you want to add:


    With Windows accounts, you don't create the account. The account already exists in the OS. Instead, you GRANT the windows account access to the appropriate database. See SQL BOL sp_grantlogin.

    EXEC sp_grantlogin 'B\UserName'
    EXEC sp_grantlogin 'C\UserName'

    Note that you would then need to grant access to the appropriate database using sp_grantdbaccess. Example:

    Use MyDatabase

    EXEC sp_grantdbaccess 'B\UserName'
    EXEC sp_grantdbaccess 'C\UserName'

    Note that B\UserName and C\UserName are not the same entities; they may share a common UserName, but the are distinct and separate. Pass-through authentication does not apply here since these are domain accounts.

    If this does not help you to solve your issue, may I suggest that you post the actual details of your situation so we can understand the issue better?


    Hugh Scott

Posting Permissions

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