what's involved in converting to window authentication

#1

currently using sql server 2005 to store our data
and historically, we've been using sql server authentication because
the msaccess application was just 'reporting' on the data

so we would have one 'read only' user that would be used to link all
tables

but we'd like to introduce tigher permissions on some reporting
to do this, we'd like to use window authentication
I'm just wondering how that would affect the linking of the tables ?
do they have to be relinked for each windows user ? or can I use AD
credentials to authenticate with sql server ?

just looking for ideas

#2

I have not used SQL Server, but linked tables to Jet and Sage need not be
available unless you application attempts to open them.

"Roger" <lesperancer (AT) natpro (DOT) com> wrote

Quote:

currently using sql server 2005 to store our data
and historically, we've been using sql server authentication because
the msaccess application was just 'reporting' on the data

so we would have one 'read only' user that would be used to link all
tables

but we'd like to introduce tigher permissions on some reporting
to do this, we'd like to use window authentication
I'm just wondering how that would affect the linking of the tables ?
do they have to be relinked for each windows user ? or can I use AD
credentials to authenticate with sql server ?

just looking for ideas

#3

Roger <lesperancer (AT) natpro (DOT) com> wrote in
news:9e68c3b3-7fdd-462d-96ad-9874d0ca631f (AT) x42g2000yqx (DOT) googlegroups.co
m:

Quote:

currently using sql server 2005 to store our data
and historically, we've been using sql server authentication
because the msaccess application was just 'reporting' on the data

so we would have one 'read only' user that would be used to link
all tables

but we'd like to introduce tigher permissions on some reporting
to do this, we'd like to use window authentication
I'm just wondering how that would affect the linking of the tables
? do they have to be relinked for each windows user ? or can I use
AD credentials to authenticate with sql server ?

No. Because the links say that it's Windows Authentication, there is
no username/password stored in the links at all. Windows takes care
of talking to SQL Server and authenticating the user.

It's MUCH easier than SQL Server authentication.

And to control access, you just create some user groups and put your
users in the appropriate groups and then assign them to the
appropriate SQL Server roles (or assign the permissions for the
groups directly, which is less desirable).

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

#4

On Aug 31, 8:32*pm, "David W. Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:

Quote:

Roger <lesperan... (AT) natpro (DOT) com> wrote innews:9e68c3b3-7fdd-462d-96ad-9874d0ca631f (AT) x42g2000yqx (DOT) googlegroups.co
m:

currently using sql server 2005 to store our data
and historically, we've been using sql server authentication
because the msaccess application was just 'reporting' on the data

so we would have one 'read only' user that would be used to link
all tables

but we'd like to introduce tigher permissions on some reporting
to do this, we'd like to use window authentication
I'm just wondering how that would affect the linking of the tables
? do they have to be relinked for each windows user ? or can I use
AD credentials to authenticate with sql server ?

No. Because the links say that it's Windows Authentication, there is
no username/password stored in the links at all. Windows takes care
of talking to SQL Server and authenticating the user.

It's MUCH easier than SQL Server authentication.

And to control access, you just create some user groups and put your
users in the appropriate groups and then assign them to the
appropriate SQL Server roles (or assign the permissions for the
groups directly, which is less desirable).

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
contact via website only * *http://www.dfenton.com/DFA/

thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

what's involved in converting to window authentication

comp.databases.ms-access comp.databases.ms-access

what's involved in converting to window authentication - 08-31-2010 , 12:49 PM

Re: what's involved in converting to window authentication - 08-31-2010 , 04:24 PM

Re: what's involved in converting to window authentication - 08-31-2010 , 09:32 PM

Re: what's involved in converting to window authentication - 09-01-2010 , 06:20 AM