Windows Authentication Passthrough - Connection String?

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?
AptDevAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

BrandonGalderisiCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
BrandonGalderisiCommented:
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.