Authenticate to MS SQL using alternate NT credentials

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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?
 
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?
Click to expand...

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

John W. Vinson[MVP]
 
Back
Top