What is the difference between windows authentication and
sql server authentication
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
How do I run a trace in sql server?
What is importing utility?
Do you know what guidelines should be followed to help minimize deadlocks?
What is the difference between char, varchar and nvarchar?
How to use old values to define new values in update statements in ms sql server?
Name and describe few console utilities for ssrs?
What is merge join?
What is meant by indexing files?
What is report snapshot?
What is 3nf normalization form?
What is federation member?
what is blocking? : Sql server database administration
What is open database communication (odbc)?
How to optimize stored procedure optimization?
Explain stored procedure?