Groups | Blog | Home
all groups > sql server connect > may 2004 >

sql server connect : NT Group user can not connect to Database


Amy
5/7/2004 1:16:15 PM
SQL2000, sp3,

Give windows authintication permission to NT group "Test"
with 50 users but not work, but it works when give 50
users windows authintication permission individually.

Anybody can help me? Any setting problem for NT group or
Amy
5/7/2004 2:01:07 PM
When I give permission to group, no error.
When I tried to connect to server, I got the following
error:

Connection failed
SQLstate:'28000'
sql server error: 18456
[microsoft][odbc sql server driver][sql server] login
failed for user "Domain\user1"


Also, I made a backup of the database and restore it to
another server, the group works fine. So it looks like the
server problem. Any idea about it? Thanks
rboyd NO[at]SPAM onlinemicrosoft.com
5/7/2004 8:42:28 PM
What happens when you give the group access? What errors do you get when
the users attempt to connect? Or does the problem occur when they attempt
to access a database?

Rand
This posting is provided "as is" with no warranties and confers no rights.
AddThis Social Bookmark Button