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
What programming language would you use to create embedded functions in ssrs?
What is meant by indexing?
What does the on update no action do?
can SSRS reports Cache results?
How to loop through result set objects using mssql_fetch_array()?
How to count groups returned with the group by clause in ms sql server?
Can we perform backup restore operation on tempdb? : sql server database administration
What different steps will a sql server developer take to secure sql server?
How to make conditional sum in ssrs?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
Explain about unique identifier data type in sql server?
what is hash nonclustered index
What is the datatype of rowid?
how many no of arguments can be passed in procedures and functions