Link to home
Start Free TrialLog in
Avatar of wilpitz
wilpitz

asked on

Trying to create a login for SQL server 2005 for an Access Data Project

I am trying to set-up an Access Data Project front end so users can edit a mass call list we received that is on a SQL server. I have had luck adding users to the server by adding them to the server by the windows login name but I am trying to use a specfic name in the ADP and not an windows login. I have the server set to SQL Server and Windows Authentication mode but I dont see anywhere to create a generic login for a database.
Avatar of Chris Mangus
Chris Mangus
Flag of United States of America image

Create a domain group for all your users of this database and add them to it.  Then, add the group just as you would a domain login, to your SQL Server with appropriate permission.
ASKER CERTIFIED SOLUTION
Avatar of dqmq
dqmq
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial