Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Please explain on Authentication ...
Message
From
09/04/2001 16:22:48
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Security
Title:
Please explain on Authentication ...
Miscellaneous
Thread ID:
00493760
Message ID:
00493760
Views:
52
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
Next
Reply
Map
View

Click here to load this message in the networking platform