Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 24035 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
Explain system rowset functions?
How to create a stored procedure with a statement block in ms sql server?
What is a unique index?
How to modify an existing user defined function?
Is sql different from sql server?
Explain the collation?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is command parameter in ssrs?
Explain logical operators in sql server?
Explain about extended stored procedure?
What is advantage data architect?
What is the significance of null value and why should we avoid permitting null values?
Explain primary key, foreign key and unique key?
Mention the 3 ways to get a count of the number of records in a table.
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
