INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

SQL Server Security

using NT Authentication to login into SQL by DougP
Posted: 1 Jun 01 (Edited 2 Dec 02)

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.



Back to Microsoft SQL Server: Programming FAQ Index
Back to Microsoft SQL Server: Programming Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close