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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-21 : 10:11:41
|
| Anibal writes "Hi,We are currently using NT Authentication to gain access to the SQL Server through client/server VB apps. Our Network Team creates the group on the domain and adds the users to that domain group. We then add the domain group to the SQL Server. Every now and then a user in the group is denied access. If we explicitly define the user, it works fine. Any idea why SQL Server is not seeing the user as part of the group?Thanks" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-01-21 : 10:34:41
|
| When you say "explicitly define the user", do you mean this:domain\username? |
 |
|
|
anibal
Starting Member
4 Posts |
Posted - 2002-01-22 : 09:24:33
|
quote:
When you say "explicitly define the user", do you mean this:domain\username?
Yes. And for groups we use domain\groupname.Thanks |
|
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-01-22 : 10:01:12
|
| This sounds more like an NT security problem than a SQL Server problem. The next time you are denied access, I suggest logging into the SQL Server with a username in that group and see if it lets you login without explicitly defining the user. |
|
|
|
anibal
Starting Member
4 Posts |
Posted - 2002-01-22 : 10:35:29
|
| Thanks for your reply. I can try that. But I know that users in the group can access the server without any problems and just one user who is getting denied belongs to the same group. I think I may have our server guys call MS for this one.Thanks again. |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-01-22 : 13:35:31
|
| What error are they getting? Is it login failed, or something else?-Chad |
|
|
|
anibal
Starting Member
4 Posts |
Posted - 2002-01-22 : 15:18:15
|
quote:
What error are they getting? Is it login failed, or something else?-Chad
I'm pretty sure its "Access Denied", but I'm not 100% sure |
|
|
|
|
|
|
Sql Server and NT User Groups