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.
Bookmarks