SQLdba (8/25/2009)
But only demand is we should use otherdomain\serviceaccount to connect to sql server.
What type of app is it? If it's a web application, say ASP.NET-based, you can specify a service account. If it's a fat client a user kicks off inidividually, unless the app is written to know how to use a different set of credentials, this isn't doable (unless you want every user to have that service account). Can you talk a bit more about the application?
K. Brian Kelley
@kbriankelley