Using network credentials to log on to other applications

Experts,

We have applications that require username and ID to access certain databases.  The environment is changing now that the userid and password will now be the same as the username and password that is used to get into the system.

Is there a way for the system to use these credentials without them having to be stored somewhere which now takes the security away from others who may have access to your machine retrieving your password.
moriniaAdvanced Analytics AnalystAsked:
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.

strivoliCommented:
Some applications might use the same credentials used to access the Windows client. This is called "Pass-Through Authentication". Example DOMAIN\User1 logs in to the computer called CLIENT1. When User1 opens Application1 the same credentials are used to run the Application1. If this is what you do not want, either:

a. Disable Application1's Pass-Through Authentication, or
b. Create more Users that can access the CLIENT1.
0
moriniaAdvanced Analytics AnalystAuthor Commented:
Pass the authentication is what I want to use.  The question is how to set that up on an access database that is currently pulling in the password and ID from a file stored on each user's desktop in the user file.

This was not too bad because it was only the ID and password for one table. However putting network credentials on your machine to me is dangerous. I am trying to find out how this application can use pass thru authentication.
0
kevinhsiehCommented:
Please see this article for differences between SQL and Windows authentication for accessing SQL databases. It explains why Windows authentication is more secure.

http://msdn.microsoft.com/en-us/library/ms144284.aspx
0
Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

moriniaAdvanced Analytics AnalystAuthor Commented:
Kevin,

I understand why Windows Authentication is more secure.  That is not the issue I have.  My area has "self-made" jobs that run against the servers and have been automated.  Currently the userid and password are being retrieived from the user's personal computer in a file.  We each had individual accounts with our own individual password and ID.

We are now as a company changing where our Windows ID and Password will be used to get us into all Servers.  My area wants us to put the windows ID and password in the same location that we previously put the individual ID and password so our automated jobs can run.

I am contesting this saying that the Windows/Network password should nebvr be stored anywhere because somone with admin access to your PC can get access to everything (even log in as you).

I am looking as to how in our database the network id and password can be retrieved without being hardcoded and visible anywhere.

I am looking for alternatives to give my management so we don't have to put our passwords where they are visible.
Most applications "***********" password so even if you type it in, it is not visible.
0
kevinhsiehCommented:
You shouldn't need to store the credentials anywhere if you are running the jobs from your user session. Anything you run as you inherits your access tokens and hence would have the same access to SQL integrated authentication without the need to input credentials. If you ran from a scheduled task you would need to save.credentials when creating the task, but the task itself would have the same access as whatever account was used for the saved credentials.
0
Stef95Commented:
Delete them from windows crenditals manager
0
moriniaAdvanced Analytics AnalystAuthor Commented:
Is there a way to hide the password with ********** like some applications.   This is an access application that we use to run our automated jobs that seemingly have to reF the userid and password from a table.  

This is why I was hoping to find a way to pass the credentials without putting them in the database.
0
kevinhsiehCommented:
Can't Access just use an ODBC connection that uses Windows authentication?
0
moriniaAdvanced Analytics AnalystAuthor Commented:
kevinhsieh,

Can you give me an example of a connection where just the ODBC Driver name used.?  All of the examples I have ask for UID and PW also/
0
kevinhsiehCommented:
When you setup an ODBC conenction to SQL server and use "With Windows NT authentication using network login ID" it doesn't ask for a username or password, because it uses the credentials of the current 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
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
Windows Networking

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.