This is for using NT authentication (NT users already setup in the Domain) So you need to get the correct spelling of each user in User Manager for Domains. Then it will get the user from NT when they log in and bingo they have permissions to the SQL server database too.
Open the Server Group and find the server to use Click the ôSecurityö location in the list below your server.
This will show 4 items: Logins Server Roles Linked Servers Remote Servers
Since The default roles are already in place. go to Logins and open it. You show see a few default logins (leave those alone)
Then Right click on the ôLoginsö and click ôNew Loginàö You should be on the ôGeneralö TAB (look at the very top of this dialog box) In the Name box at the top, key in the NT User Domain name exactly. Check the Windows NT Authentication box. Pick the Domain from the drop down box. In the Defaults (at the bottom) pick the Database you want them to default to:
Next at the top click the Database Access TAB Put a check next to the database name (this is on the far left) Then at the bottom choose the öRoleö I choose ôPublicö (put a check in it) Then click the OK button and thatÆs it. For this portion.
Make sure the Role has permissions to the Tables you want to use.
---------------------------------------------------------- Now then you need to make sure the "Public" Role has the correct permissions for the database you want to use. So under the database name which is back up the list a ways . ôUniversalö in our case click the öRolesö section. And you should see "Public" listed there, double click it. Then click the Permssions button, upper right This will list all of the tables in that database. You can then check or uncheck permissions to each table and access to it like, Select, Insert, Update, Delete, etc. by putting a check box in the column.
Then click OK. Back on the "General" TAB you should see the users you set up in the top of this discussion.
Click OK And your users should be able to Access the SQL Server through a DSN.