Rabu, 20 Juli 2011

RE: [MS_AccessPros] Users cannot connect to SQL tables

The solution we use at my employer is to create a security group on the server. Assuming the server is "SERVER_A" and you application is "MyApp" we would have a group:
SERVER_A\MyApp_Users

We would then add any active directory groups to this server security group. Then open SQL Server Management Studio and create a new login in SQL Server for SERVER_A\MyApp_Users and grant the appropriate permissions to your database(s). This is typically db_datareader and db_datawriter. If you are using SQL Server 2005 you would also need to grant permissions to run stored procedures if you have any.

You will only need to maintain the active directory groups to provide access to the database. I use DSN-less connections with code from Doug Steele's page http://www.accessmvp.com/djsteele/DSNLessLinks.html.

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: winberry.doyce@roadsysinc.com
Date: Wed, 20 Jul 2011 17:15:28 +0000
Subject: [MS_AccessPros] Users cannot connect to SQL tables


Hello friends,

I'm new to SQL server so I need some help. I just migrated my ERP software to SQL Server. I have an Access 2007 front end linked to some of the tables in it. My users cannot connect to the linked tables. It is an authentication issue. I setup an OBDC connection that works fine for me but then I'm the DBA. How do I set them up permissions to authenticate to SQL. I have an active directory user group that I'd like to assign rights, however, I don't how to do that in SQL server management console. It is version 2008 R2.

Doyce


[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar