What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 21534 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / adedewe bliss
SQL Authentication :
SQL Authentication is the typical authentication used for
various database systems, composed of a username and a
password. Obviously, an instance of SQL Server can have
multiple such user accounts (using SQL authentication) with
different usernames and passwords. In shared servers where
different users should have access to different databases,
SQL authentication should be used.
Windows Authentication :
When you are accessing SQL Server from the same computer it
is installed on, you shouldn't be prompted to type in an
username and password. And you are not, if you're using
Windows Authentication.
NOTE: AFTER LOGIN USING WINDOS AUTHENTICATION, YOU WILL BE
REQUIRED TO SAVE ANY MODIFICATION INTO A PROJECT FOLDER.
THIS WILL HELP YOU WHEN EVER YOU WANT TO LOGIN USING SAME ID
& PASSWORD. IF YOU FAILS TO SAVE: FOR YOU AND YOUR USERS AT
THE OTHER WORKSTATION TO LOGIN SAME ERROR WILL COME 'Login
failed for user 'sa' because the account is currently locked
out'. IN OTHER WORDS, YOU HAVE TO SAVE YOUR MODIFICATION,
UPLOAD IT AT THE NEXT LOGIN.
| Is This Answer Correct ? | 10 Yes | 2 No |
Post New Answer View All Answers
You want to implement the many-to-many relationship while designing tables. How would you do it?
How can I know what locks are running on which resource?
What is the difference in accessing db between sql server vs sql azure?
How do I open a .db file?
Explain what are the basic functions for master, msdb, model, tempdb databases?
Explain the Ways to improve the performance of a sql azure database?
What are tables in sql server?
Please explain go command in sql server?
Why union all is faster than union?
What is attribute relationships, why we need it? : sql server analysis services, ssas
Do you know what are pages and extents? : SQL Server Architecture
How to truncate the log in sql server 2012? : sql server database administration
Define outer join in sql server joins?
application server is slow what may be the problem
What do you understand by a view?
