Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Jerome Mackels
Starting Member
4 Posts |
 Posted - 2003-05-20 : 03:27:39
|
| Hi,My question is related to DB Access Right and NT Group Security. At the end, I want that the user connect to the Database with the “Windows Authentification”. Some NT Groups already exist on the Domain. I want to use directly these NT Groups to associate to a role. In that way, all the members of this group will have access to the DB.If I set the NT Group on the SQL Server computer and if I use it to give some right, everything works. But the problem comes when I want to use the NT Group (with active directory) from the domain, which is not on the same computer. I can give the access to the group, but when a member of this group tries to connect to the DB, we have a Login Error. It seams that SQL Server cannot identify the member of the Domain NT Group.All the operation that I've done was on SQL Server 7 and with the Enterprise Manager.Do you have already encounters this problem? I’ve looked in the Books Online, it just says use syntax like that “Domain\NTGroupName” and nothing else. Is it due to a config on the domain?If you can help me, you are welcome.Regards,Jmackels |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-05-20 : 12:35:22
|
| Is the SQL server part of that domain?-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-20 : 12:41:27
|
| This has worked perfectly fine for me so far, so I wonder if the user is actually a member of the group or if the group really has access to the SQL Server. Verify both of these things. As long as SQL Server can see the group, then everything should work fine. Did you receive any errors when you added the group to the SQL Server?Tara |
|
|
|
|
|
|
|
|
NT Groups and SQL Server Access Right