Logging Into Sql Server Of Different Domain From .Net
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
Have you discussed this issue with the DBAs in responsible for the SQL Server in DomainA?
I don't answer coding questions via PM or Email. Please post a thread in the appropriate forum section.
Please use [Code]your code goes in here[/Code] tags when posting code.
Before posting your question, did you look here
Got a question on Linux? Visit our Linux sister site.
Modifications Required For VB6 Apps To Work On Vista
Thanks for the reply Hack, was waiting for your reply. I was hoping either you or Phil will reply.
Originally Posted by Hack
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.
By alex in forum Database
Last Post: 11-03-2005, 05:27 AM
By Aditya in forum Database
Last Post: 04-29-2002, 07:39 AM
By David Jones in forum Database
Last Post: 08-31-2001, 12:22 PM
By andriano in forum Enterprise
Last Post: 10-02-2000, 03:54 PM
By Devaraj in forum Enterprise
Last Post: 05-11-2000, 12:48 PM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center