What are the authentication modes in SQL Server? How can it be changed? ,Java, C ,C++, ASP, ASP.net C# ,Struts ,Questions & Answer, Struts2, Ajax, Hibernate, Swing ,JSP , Servlet, J2EE ,Core Java ,Stping, VC++, HTML, DHTML, JAVASCRIPT, VB ,CSS, interview ,questions, and answers, for,experienced, and fresher
What are the authentication modes in SQL Server? How can it be changed?

Mainly Two modes are the Authentication Modes in SQL Server they are following as : 
Windows mode and Mixed Mode : SQL And Windows.
Process of change the Authentication Mode in SQL Server :  To change authentication mode in SQL Server click Start > Programs >  Microsoft SQL Server >  click SQL Enterprise Manager .
        When the open the Window of SWL Enterprise Manager it means it start to run from the Microsoft SQL Server program group. Now Select the server then going to Tools menu > select SQL Server Configuration Properties, and choose the Security page.

More interview questions and answers
What are the properties of the Relational tables?
What do you understand about Numeric array, Associative array and Multidimensional array?
What is De-Normalization?
What is the mean of Nested Trigger?
What is a Linked Server?
What do you understand about looping in PHP?
What is Cursor?
What is Collation?
What is Difference between Function and Stored Procedure?
What is the Sub-Query?And what is the properties of Sub-Query?
How to use while,do..while,for and foreach loop in PHP?
Give the list how many type of Joine?
Define : What is the Cross Join?
give us a definition of Inner Join?
What do you mean by Outer Join? and define also how many types of Outer Join?
Defeine : Self Join?
What is User Defined Functions?
What kind of User-Defined Functions can be created?
What do you understand functions in PHP?How we create them?
What is Identity?
What is DataWarehousing?
What is the clustered index?
What do you mean by A non clustered index?
How to handle form in PHP?
What are the different index configurations a table can have?
What are different types of Collation Sensitivity?
What is OLTP?
What is form validation?What is Client Side and Server Side validation?
What do you mean by TRUNCATE?
What do you mean by DELETE command?
When is the use of UPDATE_STATISTICS command?
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
What are the properties of SUB-QUERY?
What is the difference between constants and variables in PHP?
What are the type of SUB-QUERy?
What is SQL Profiler?
What is Ant?
What is a build tool?
How many types of build tool you know?
What is different between Ant and Make?
What is History of Ant?
Which version of Java is required to run Ant?
What are the authentication modes in SQL Server? How can it be changed?
Why do you call it Ant?
What is SQL Server Agent?
When we used $_GET and $_POST variable?
How you can Prepare a project in ANT?
Why we use $_REQUEST variable?
From where we can download Ant latest version?
Can a stored procedure call itself or recursive stored procedure? How much level SP nesting is possible?
Why we use Date() function in PHP and How?
What is Log Shipping?
Why we used Server Side include function?
What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?
How we use include() and require() function in PHP?
What is the mean of Local temporary table?
How to use File Handling in PHP?
What do u mean by Global temporary table?
What types of modes we use in PHP for File Handling?
How we use fopen(),fclose(),feof(),fgets() and fgetc()in PHP?
How we can set the PATH environment variable of ant?
What you know about Cookie?
What operation we can perform with Cookie?Explain it?
How we Sessions in PHP?
What is the STUFF function and how does it differ from the REPLACE function?
How we handle errors in PHP ?
How we use Simple \"die()\" statements error handling method in PHP?
What is PRIMARY KEY?
How we use Custom errors and error triggers error handling methods in PHP?
What is UNIQUE KEY constraint?
What is FOREIGN KEY?
How we use Error logging method in PHP?
What is CHECK Constraint?
What is NOT NULL Constraint?
What is a Scheduled Jobs or What is a Scheduled Tasks?
What are the advantages of using Stored Procedures?
What do you understand about Exception Handling in PHP?
What is BCP? When does it used?
How to implement one-to-one,one-to-many and many-to-many relationships while designing tables?
What is Filter?How we use them?
Can a java source file hava more than one public classes?
What is an execution plan? When would you use it? How would you view the execution plan?
What do you mean by The master database?
Define The msdb database?
What do u mean by The tempdb?
What is the mean of The model?
Define whats the mean by Resoure Database?
What is Service Broker?
What is .htaccess file and how to use them?
What is Policy Management?
What is the difference b/n \'action\' and \'target\' in form tag?
What is the substitution of submit in PHP?
What is the DDL,DCL and DML?
What is the difference b/w PHP4 and PHP5?
What is Replication and Database Mirroring?
What are Sparse Columns?
What is the difference between $i and $$i?
What does TOP Operator Do?
Write some array sort functions available in php ?
What is CTE?