What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 22451 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
How to list all field names in the result set using mssql_field_name()?
Do you know what is normalization of database? What are its benefits?
Does partitioning improve performance sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
Explain different types of Normalization.
Explain foreign key in sql server?
Why use identity in sql server?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Why the trigger fires multiple times in single login?
What are different types of raid levels?
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
What is xdr?
What is cursors? And what are the different types of cursor?
What are the functions in sql server?
What is a field in a table?
