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 existsA 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:

B\UserName
C\UserName

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?

Regards,

Hugh Scott