Connection Failed

SQL 2000
Windows 2000 sp4

I have created a group called "queryonly" in Active Directory. I have
added myself to this group. When I attempt to create an ODBC connection
to the SQL server I get "connection failed".

When I add myself explicity (ie domain\user) it connects fine.

Why is the group not working? I want to cut down on some
administration.

Thanks.

JustinJustin wrote:
> SQL 2000
> Windows 2000 sp4
> I have created a group called "queryonly" in Active Directory. I have
> added myself to this group. When I attempt to create an ODBC connection
> to the SQL server I get "connection failed".
> When I add myself explicity (ie domain\user) it connects fine.
> Why is the group not working? I want to cut down on some
> administration.
> Thanks.
> Justin

Hi Justin,

Make sure that you log off and then log in after adding yourself to the
group. Sounds stupid, but it seems to work for me :)

Michael