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 policy based management (pbm)? : sql server database administration
where the connection string store in the database
How to edit table in sql server 2017?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
How to download and install microsoft sql server management studio express?
How can you check the level of fragmentation on a table?
What are the requirements for sql server 2016?
What is the difference between indexing and hashing?
What are the different types of sql server replication? : sql server replication
What are filegroups in sql server?
What is ms sql server reporting services?
What are translations and its use? : sql server analysis services, ssas
Can you please explain the difference between primary keys and foreign keys?
do you know how to configure db2 side of the application? : Sql server database administration
What is a select query statement in ms sql server?