[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2010-09-20
1
Medium Priority
?
296 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

649 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