Hi Friend, I have a Domain named "A", all my Client computer and SQL Server(2000) logs on to that domain, now I have used Trusted Connection to connect to SQL Server (for an windows application installed on client computer). It works fine.
But the problem is that, the client system also uses a seperate web application which is deployed at Seperate Domain say "B" and it prompts for user's credentials to access the page. and when the user enters B\UserName and Password (to access the web application hosted on Domain B), after entering Domain user's credentials of "B" SQL Server denies to Establish/Open/Use connection to it. I have tried Setting - Persist Security Info = True (Property of Connection String) System Config. Client OS : Windows XP Domain (A) : Windows 2003 Advance Server Domain (B) : Not Known SQL Server2000 : Windows 2003 Advance Server Please Suggest how it can be resolved.
