Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
NT Groups and SQL logins
Message
De
05/01/2000 09:35:25
John Deupree
Long Term Care Authority
Tulsa, Oklahoma, États-Unis
 
 
À
05/01/2000 08:33:54
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Divers
Thread ID:
00312417
Message ID:
00313165
Vues:
44
>I'm at a loss. You have an NT Group that you've given authority to log into the server. The users are members of that NT Group. When you make the DSN, are you checking the box NT Authentication box?
>

Definitely. The NT group is a local group (for the domain), not global. As I mentioned, SQL resides on a stand alone server. I mention that because I had some problems starting the SQLExec service using a non system account (I didn't do the install) because of a permissions problem. I had to add the account to the local (machine) admin group.
I can log onto my (NT) workstation as test1 (a member of SQLUsers group) and, using the query analyzer, cannot access SQL. After I add test1 to the logins, I can access it with no problem.

Thanks
John
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform