What is the difference between windows authentication and
sql server authentication
Answer Posted / visala
windows authentication has a concept of ACL(access control
list). Means in a group we can give permissions/restriction
to a perticular person in a group individually.
Is sql authentication there no concept of ACL. Means we
can't give permissions/restrictions individually. we can
give permissoins to the hole group .
in windows we can give permissions before enetering into
the server.
in sql we can give permissions after entering into the
server only.
| Is This Answer Correct ? | 11 Yes | 5 No |
Post New Answer View All Answers
Explain for xml explicit mode?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
what is the difference between count(*) and count(1) ?
How does index makes search faster?
What is the difference between a stored procedure and a user defined function?
What happens if null values are involved in boolean operations?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
What is the cartesian product of table?
Can we add a cpu to sql server?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
How to restore performance issues and how to check?
What are the advantages of using third-party tools?
What is transaction server distributed transaction?
What type of Index will get created after executing the above statement?
What is it’s similarity with sql server?