Connection Question to SQL

[Art]

I have always appreciated this group and the wealth of knowledge present.

I am using FP2002 and wish to connect to an existing SQL database just for
retreival of data. Usually no problem in creating the database connection
except that in this case I want the query to use NT authentication instead of
a name and password enbedded into the databse connection. Can this be done?

We have the SQL table locked down so only a hand full of users can access (
Human Resource Records). If I add a name and password to the connection, it
will open it up for all.

Our overall intranet is set to anonymous access.

Any suggestions anyone?

Thanks

 

[Art]

One other option I just thought of was to use the name/password in the
connection but to put the asp page in a restricted folder. Would appreciate
comments.

 

[Kevin Spencer]

Hi Art,

First of all, you can't use Windows Authentication unless the site does not
allow anonymous visitors. The ASP application will run under the anonymous
Internet User account.

You could use SQL Server logins to do this. You would have to use a form to
get the user to log in, and then build your Connection String dynamically,
inserting the login password and user name into the string.

--
HTH,

Kevin Spencer
Microsoft MVP
Professional Chicken Salad Alchemist

What You Seek Is What You Get.