ALLInterview.com :: Home Page Forum9.Com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories >> Software >> Databases >> SQL-Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
Question
What is the difference between windows authentication and
sql server authentication
 Question Submitted By :: Durga Prasad
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What is the difference between windows authentication and sql server authentication
Answer
# 1
Windows authentication is more securable compare to mixed 
mode authentication.
 
Is This Answer Correct ?    0 Yes 0 No
Hari
 
  Re: What is the difference between windows authentication and sql server authentication
Answer
# 2
SQL Authentication : 
SQL Authentication is the typical authentication used for 
various database systems, composed of a username and a 
password. Obviously, an instance of SQL Server can have 
multiple such user accounts (using SQL authentication) with 
different usernames and passwords. In shared servers where 
different users should have access to different databases, 
SQL authentication should be used. Also, when a client 
(remote computer) connects to an instance of SQL Server on 
other computer than the one on which the client is running, 
SQL Server authentication is needed. Even if you don't 
define any SQL Server user accounts, at the time of 
installation a root account - sa - is added with the 
password you provided. Just like any SQL Server account, 
this can be used to log-in localy or remotely, however if 
an application is the one that does the log in, and it 
should have access to only one database, it's strongly 
recommended that you don't use the sa account, but create a 
new one with limited access. Overall, SQL authentication is 
the main authentication method to be used while the one we 
review below - Windows Authentication - is more of a 
convenience. 
Windows Authentication : 
When you are accessing SQL Server from the same computer it 
is installed on, you shouldn't be prompted to type in an 
username and password. And you are not, if you're using 
Windows Authentication. With Windows Authentication, the 
SQL Server service already knows that someone is logged in 
into the operating system with the correct credentials, and 
it uses these credentials to allow the user into its 
databases. Of course, this works as long as the client 
resides on the same computer as the SQL Server, or as long 
as the connecting client matches the Windows credentials of 
the server. Windows Authentication is often used as a more 
convenient way to log-in into a SQL Server instance without 
typing a username and a password, however when more users 
are envolved, or remote connections are being established 
with the SQL Server, SQL authentication should be used.
 
Is This Answer Correct ?    0 Yes 0 No
Hari
 
 
 
  Re: What is the difference between windows authentication and sql server authentication
Answer
# 3
windows authentication has a concept of ACL(access control 
list). Means in a group we can give permissions/restriction 
to a perticular person in a group individually.
   Is sql authentication there no concept of ACL. Means we 
can't give permissions/restrictions individually. we can 
give permissoins to the hole group .
   in windows we can give permissions before enetering into 
the server.
    in sql we can give permissions after entering into the 
server only.
 
Is This Answer Correct ?    0 Yes 0 No
Visala
 
 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How to Execute an Operating System Command From Within SQL Server ?  2
1. What are the grouping function in SQL ? 2. If base table of a view deleted means, what will happen while we querying on view ? will give any error ? 3. Difference between DROP, DELETE, TRUNCATE table ? 4. What is constraints and types ? 5. What is max size of nchar & nvarchar ? 6. Define ROLLBACK, COMMIT, SAVE POINT 7. How non-clustered better ? or rank the Clustered, Non-Clustered and Table scan in performance wise 8. Select 10 rows from a table ? 9. Define DML, DDL, DCL, DTL commands ? 10. What is mean by NULL value ? NULL means "" or 0 or undefined ? 11. Default constraints ? 12. Can we have more then primary Key in table ? 13. Type of integrity ? Entity, Referential, Domain ? Perot-Systems7
any one can explain Self mapping Delegation Remote Credentials  1
What are the differences between stored procedure and functions in SQL Server 2000? TCS7
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?  1
What is the system function to get the current user's user id? TCS1
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz  6
create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error? IBM1
What are three SQL keywords used to change or set someone?s permissions?  3
Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?  2
How do we get month name in SQL Server 2000, Oracle, MS Access?  4
What is a trigger?  3
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  2
what is differece between union and union all  3
i have 4 tables.. T1, T2, T3, T4.. these tables have the same structure and they store the information entered in different years.. T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored 2005.. i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and T4 to T1.. how do i do that? Temp tables cannot be used..  1
can we call stored Procedure in Function in Sql Server 2000 and vice versa. eSoft1
Explain some DBCC commands?  3
when we use function instead of procedure? plz tell me the situation with ex?  1
What is an extended Stored Procedure?  1
Difference Between varchar and nvarchar datatype? Satyam1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com