Logging Into Sql Server Of Different Domain From .Net


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Logging Into Sql Server Of Different Domain From .Net

  1. #1
    Join Date
    Aug 2006
    Posts
    84

    Logging Into Sql Server Of Different Domain From .Net

    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

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,666
    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

  3. #3
    Join Date
    Aug 2006
    Posts
    84
    Quote Originally Posted by Hack View Post
    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.

Similar Threads

  1. SQL Mail Problem
    By alex in forum Database
    Replies: 3
    Last Post: 11-03-2005, 05:27 AM
  2. Replies: 0
    Last Post: 04-29-2002, 07:39 AM
  3. Access & SQL Server
    By David Jones in forum Database
    Replies: 0
    Last Post: 08-31-2001, 12:22 PM
  4. Remove exchange from a site
    By andriano in forum Enterprise
    Replies: 1
    Last Post: 10-02-2000, 03:54 PM
  5. Re: ODBC error
    By Devaraj in forum Enterprise
    Replies: 0
    Last Post: 05-11-2000, 12:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center