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 is subreport?
How to insert new line characters into strings?
What is set nocount on?
What are the two modes of authentication in sql server?
Why we use trigger in sql server with example?
Can You Use Data Mining Models In Ssrs?
Tell me the difference between clustered and non-clustered index?
What is a Join and explain its types?
How to view existing indexes on an given table using sp_help?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What are the advantages of paper records?
Where do you find the default Index fill factor and how to change it?
What are the differences between triggers and stored procedures?
I have all the primary data files, secondary data files as well as logs. Now, tell me can I still restore the database without having a full backup? : sql server database administration
What is the stored procedure?