What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 22498 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / ramadass
With windows authentication, we can not do database access
by giving role,permission where as we cand do it for SQL
server authentication.
We can not control the windows authentication user over the
DB.
Windows authentication user by default having the Admin
access in sql server. so we can not control them.
| Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What are dml triggers and types of dml triggers?
What is row_number () and partition by in sql server?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What are the new data types are introduced in sql 2000?
What is 2nf in normalization?
What is a with(nolock)?
Explain what is sql server english query?
What is an indice?
What is sql server locking?
Explain filestream storage of sql server 2008?
Which is the main third-party tool used in sql server?
Can a database be shrunk to 0 bytes, if not, why?
What is 2nf normalization form?
What is rtm version in sql server?
How to resolve the orphan use problem? : sql server security
