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
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is a subquery in a select query statement in ms sql server?
How to invoke a trigger on demand?
Explain user defined views?
What is database isolation in sql server? : sql server database administration
Equi join and non equi join is possible with sql server?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
What is the command used to recompile the stored procedure at run time?
What is the function of inner join?
What's the information that can be stored inside a bit column?
Explain the difference between primary keys and foreign keys?
Does a server store data?
What are audit control procedures?
What is perspective, have you ever created perspective? : sql server analysis services, ssas