security access for my .adp users to my SQL Server

[an0nyM0use]

I am having trouble creating a way for my .adp file users to connect to my SQL Server. Any ideas on how to make this work?

 

[an0nyM0use]

The access should be the same as for any kind of ODBC connection. The problem is that if I set it up for NT Logon authentication. It seems to be failing for some users. If I set up an account for the connection, I would need to do this for every individual user. Isn't there some way to leverage the iis IUSER_ account for generic logon and give that account permissions for my DB? Any ideas would be welcomed.

THanks,
Kevin

 

[an0nyM0use]

never mind, I just update the connection settings with adding the password and marking it for allow saving. I guess the only problem is that it doesn't track individual user changes, but that should be okay since the original db didn't do that either.