Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Please explain on Authentication ...
Message
De
09/04/2001 16:22:48
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Sécurité
Titre:
Please explain on Authentication ...
Divers
Thread ID:
00493760
Message ID:
00493760
Vues:
53
I'm a little confused about the security authentication "modes" in SQL Server 7 ...

Ok - you have either "SQL Server and Windows NT" or "Windows NT Only" set at the server level. This would seem to imply that "SQL Server Only" is not a choice - yet, we are able to log into SQL Servers without EVER logging into or having a password (or even an account) on/to the NT Domain. How is this possible???????

Now - there are also "Windows NT Authentication" and "SQL Server Authentication" choices on the login creation screen for the individual user. How do these properties interact with the server level properties? For example - what happens if you do Windows NT at the server level and "SQL Server" at the login level? or vice-versa?

TIA!
Ken B. Matson
GCom2 Solutions
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform