?
Solved

Windows Authentication Passthrough - Connection String?

Posted on 2008-02-11
4
Medium Priority
?
5,601 Views
Last Modified: 2008-09-20
There is a SQL Server 2005 database that I need to connect with.  I can personally connect just fine, since ALL users are connected using WINDOWS AUTHENTICATION.  But a new Active Directory user was created, just for reporting purposes, and was given read-only rights to the database.  I would like to be able to connect to the SQL Server using that user.

I can do it using SQL Reporting Services, because it allows me to enter the user name and password, and then lets me check the box "Use As Windows Credentials When Connecting To The Database."  It works fine, so I know the permissions were set up correctly.

But I have been unable to create an ODBC connection using that user.  I can't get an OLE DB connection to work.  I can't connect using Crystal Reports XI or Crystal Enterprise XI.  I can't connect using a connection string inside of VB.NET.  In fact, the only connection I can make is using SQL Reporting Services.

Is there a way I can get a connection object (a UDL file, or an ODBC link)(or a VB.NET connection string)(or something similar) to connect to that SQL Server 2005 database, using a username and password as Windows Credentials?
0
Comment
Question by:AptDev
  • 2
2 Comments
 
LVL 39

Accepted Solution

by:
BrandonGalderisi earned 2000 total points
ID: 20869525
Windows Authentication allows for running under the context of the logged in user.  If you want to use alternate windows credentials, the user would have to login (or launch the app) under the user context of THAT user.
0
 
LVL 39

Expert Comment

by:BrandonGalderisi
ID: 20869535
It would be a fairly big security hole if under you Windows Authentication, you could just say "hey... shh... pretend I am this guy instead but don't tell anyone"
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

601 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