What is the difference between windows authentication and
sql server authentication

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


Please Help Members By Posting Answers For Below Questions

Can we use pragma autonomous_transaction in trigger?

745


What is the difference between varchar and nvarchar datatypes?

799


Do you know the cursor optimization tips?

781


What is a document index?

810


What is report server project?

122


What are views used for?

815


How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

858


explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

725


What are the steps you can take to avoid “deadlocks”?

731


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2048


How can you insert values in multiple rows using one Insert statement?

845


What is the sql profiler?

713


What is equi join with example?

757


Explain what is use of dbcc commands?

756


What is the command used to recompile the stored procedure at run time?

836