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
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL