Solved

vb.net sql across 2 networks using impersonated windows authentication?

Posted on 2010-09-20
1
291 Views
Last Modified: 2012-05-10
here is my situation:

I need to access SQL DB from a network on which I am NOT on a domain. The SQL server sits on another network WITH a domain. ( all access has been arranged between the 2 networks...)

I need to be added to a read only group for that SQL server, but due to me not being on the same domain it will not allow this with my current setup.

Is there a way that I can create and use a user for that domain while impersonating a different identity than the logged on windows user of the non-domained machine from a VB.net application?

So basically in my connect string inside the application could use a user and password from a domain I am technically not logged into?

Thanks!
0
Comment
Question by:MaxDes101
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 15

Accepted Solution

by:
mcmonap earned 500 total points
ID: 33721464
Hi MaxDes101,

Have you checked whether SQL authentication is enabled on the SQLserver?  If mixed mode is/could be enabled this would resolve your issue.  It allows the configuration of accounts to authenticate against SQL server directly.  More info here (read Connecting Through SQL Server Authentication):

http://technet.microsoft.com/en-us/library/ms144284.aspx
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
When you try to share a printer , you may receive one of the following error messages. Error message when you use the Add Printer Wizard to share a printer: Windows could not share your printer. Operation could not be completed (Error 0x000006…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question