Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is subreport?

141


How to insert new line characters into strings?

975


What is set nocount on?

927


What are the two modes of authentication in sql server?

1042


Why we use trigger in sql server with example?

946


Can You Use Data Mining Models In Ssrs?

145


Tell me the difference between clustered and non-clustered index?

923


What is a Join and explain its types?

1087


How to view existing indexes on an given table using sp_help?

1110


How to get a list of columns in a view using "sys.columns" in ms sql server?

976


What are the advantages of paper records?

951


Where do you find the default Index fill factor and how to change it?

1050


What are the differences between triggers and stored procedures?

1045


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

1109


What is the stored procedure?

992