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
What is the temp table?
Explain about integration services of Microsoft SQL server?
How to create prepared statements using odbc_prepare()?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is key attribute?
where can you add custom error messages to sql server? : Sql server administration
Do you know hot add cpu in sql server 2008?
Explain different types of locks in sql server.
How do I install only the client tools of sql server 2000?
What is database replication?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are the properties of the transactions?
How to access the deleted record of an event?
How to list all dsn entries on your local machine using odbc_data_source()?
How do you start single user mode in clustered installations?