What is the difference between windows authentication and
sql server authentication

Answer Posted / raj kumar

Wnidows Authentication
1.Single User can only login
2.Not Integerated
3.Not Security

SQL Authentication
1.Multi user can login
2.Integerated
3.More security

Is This Answer Correct ?    18 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

you want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition? : Sql server administration

554


Difference between DELETE and TRUNCATE?

617


What will be query used to get the list of triggers in a database?

552


How do I partition a table in sql server?

541


What is tablesample?

578






What is temporal data type?

526


explain what is raid and what are different types of raid configurations? : Sql server database administration

552


What is the difference between drop table and truncate table?

495


What action plan is preferred if sql server is not responding?

539


What is scd (slowly changing dimension)? : sql server analysis services, ssas

598


What is the report builder?

106


How you can find out if an index is useful to the optimizer?

499


how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

1104


What is spid in sql server profiler?

542


What are sql dirty pages?

564