Your question about standalone/BDC etc. prompted me to thinking that perhaps
the access groups should be setup on the actual server rather than the
I have tried this and now have an accessible SQL server with access
controlled on the machine rather than from the domain.
The access groups can of course be made up from Domain Users and Domain
There is an advantage to this as access to the SQL Server is managed with
User Manager on the machine and reduces the clutter in the Domain User
> I found the same, are you upgrading from SQL6.5 or are you setting up a
> whole new system. Are you setting up on a stand alone NT server or a BDC
> >Hi All
> >I am just setting up SQL7 in a Domain but I can't persuade SQLServer to
> >accept logins from Local Group members. Users in a Global group can
> >the server with no problems.
> >A Global Group in the Local Group won't make it either.
> >Any hints gratefully received.
> >Nick Cooper
> >PC Support
> >University of Bath - School of Management