Sir i installed sql server 2008 in one domain i can login sql server in both login mode.Is it possible to login sql server from diffrent domain?
closed as not a real question by Michael Hampton♦, rnxrx, Magellan, Ward, Scott Pack Oct 22 '12 at 20:07
It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.
Sure, if you have a trust relationship between your domains that will allow users from the other domain to authenticate to resources in the domain that holds the SQL server. The domain with the SQL server would need to have at least a one-way outgoing trust to the other domain. You would also still need to add the relevant Active Directory users from the other domain into the SQL server Security, to allow authentication.