I have a workbook that uses an SQL query to pull data from a database.

The code currently has my userID and password (don't worry, this is what I'm trying to resolve).

The IT department has control of the DB. I inquired if I could have a generic read-only ID, and they directed me to setup NT Authentication in my code.

I have not dealt with this type of approach before.

Does anyone have references or examples of NT Authentication?

I have code to pull the userID for the person logged onto the computer, but no password.

The DB is located on '\\Production\ProductionInUse\ server.

Thank you for reading and helping.