[AccessD] Using Windows Authentication with Access/SQL Apps

Hi Dan:

I have always given MS SQL a separate Username and Password by adding a
user's new group to the network. This is a group specifically for the MS SQL
users. That group is attached via the manger to the SQL and then I use the
MS SQL credentials as the username and login.... It gives an extra layer of
protection as well as allows the adding and removing of access to the
company data depending on a site requirements... Better flexibility as well.

HTH
Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
Sent: Tuesday, November 25, 2008 9:58 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Using Windows Authentication with Access/SQL Apps

I'm working on upsizing one of my customers to SQL.  They have asked if we
could eliminate the Access workgroup username and password login that I
currently use (mostly just so the database knows who is logging in).

With SQL using Windows Authentication, my Access app could simply pick up on
the current username and go from there, without going through an additional
username and password entry.

Has anyone done this?  Any pros, cons, or gotchas?

Thanks!
Dan




-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com