Authenticate to MS SQL using alternate NT credentials

[Brad]

We are trying to authenticate to MS SQL through an MS Access application
coding in VBA and want to pass NT credentials of a service account instead of
the user that opens the MS Access app. I am aware of how to code this using
a SQL authentication, but was wondering how to do this using NT
authentication of a user other than the the person that has opened the app?

Any help or sample code would be apprecaited.

 

[David Pawloski]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Armando Blanco
Microsoft MVP

 

[Brad]

How does upgrading to 2004 solve this issue? We are currently using 2000 so
an upgrade to 2004 is not very likely. Is there some sort of built in ADODB
function in 2004 that enables creating a database connection to pass NT
authentication that 2000 doesn't have?

 

[John Vinson]

How does upgrading to 2004 solve this issue? We are currently using 2000 so
an upgrade to 2004 is not very likely. Is there some sort of built in ADODB
function in 2004 that enables creating a database connection to pass NT
authentication that 2000 doesn't have?

He's a spammer, trying to draw traffic to a warez website. Ignore him.

John W. Vinson[MVP]