Logging Into Sql Server Of Different Domain From .Net

[RoughGuy]

Hi All,

I have a problem and searched over Net for a very long time. But could not get the answer , so I thought I can get some help here.

I have Sql Server running on DomainA in which I was given access with Windows Authentication. I am writing an application which will run in DomainB and should connect with SqlServer of the DomainA.

The problem here is I am not authorized to create new user in SqlServer, So I can not use SqlServer Authentication.

I guess I can use Impersonation, but I have not got any example code of how it can be implemented to login as different user.

Can anyone suggest me a solution for my problem.

Thanks In Advance

[Hack]

Have you discussed this issue with the DBAs in responsible for the SQL Server in DomainA?

[RoughGuy]

Have you discussed this issue with the DBAs in responsible for the SQL Server in DomainA?

Thanks for the reply Hack, was waiting for your reply. I was hoping either you or Phil will reply.

Actually this application is for my personal use which will automate a process. So I can not discuss with the DBA team and get the permissions other than my existing Windows Authentication.