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 are the authentication modes in SQL Server?

Answer Posted / dupinder singh

SQL Server 2008 offers two authentication mode options:

Windows authentication mode requires users to provide a
valid Windows username and password to access the database
server. In enterprise environments, these credentials are
normally Active Directory domain credentials.

Mixed authentication mode allows the use of Windows
credentials but supplements them with local SQL Server user
accounts that the administrator may create and maintain
within SQL Server.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by subquery?

1145


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1115


What are the different Authentication modes in SQL Server and how can you change authentication mode?

1123


What is the difference between functions and scalar functions?

1278


What do you think of this implementation? Can this be implemented better?

994


What do you mean by cardinality?

938


What is page-level compression?

1009


What is the purpose of update statistics and scope_identity() function?

1158


What is replace and stuff function in sql server?

1111


What are secondary xml indexes?

1074


what data regions are and what are the different data regions?

146


What are dml triggers and types of dml triggers?

1028


What are the differences between stored procedure and the dynamic sql?

1135


what is raid and what are different types of raid configurations? : Sql server database administration

1099


What is store procedure? How do they work?

1068