Realized I should be as a proviso that I'm really simplifying things here...

As long as domain B trusts domain A, user can use domain A's user login on domain B. This is the NT 4 single master (or multiple master) model for domains. All user accounts are in a master domain. All resources (such as workstations and servers) are in the resource domain. The resource domain trusts the master domain. This allows the user account to be used on the workstation and the server.

Within Active Directory, if both domains are in the same forest, then both domains trust each other. This would be the equivalent of the "full trust" model from the NT 4 days (almost, it gets a bit more detailed in AD, but unless you have to worry about it, I won't go into any more detail). So the user should be able to login with the account from domain A on his workstation.

If the domains don't trust each other, then you'll have to create a Windows account local to the SQL Server that matches the username and password the user is using.

K. Brian Kelley

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1

Edited by - bkelley on 05/21/2003 09:39:49 AM