Answer / hari

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.

Answer / adedewe bliss

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.

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.

NOTE: AFTER LOGIN USING WINDOS AUTHENTICATION, YOU WILL BE
REQUIRED TO SAVE ANY MODIFICATION INTO A PROJECT FOLDER.
THIS WILL HELP YOU WHEN EVER YOU WANT TO LOGIN USING SAME ID
& PASSWORD. IF YOU FAILS TO SAVE: FOR YOU AND YOUR USERS AT
THE OTHER WORKSTATION TO LOGIN SAME ERROR WILL COME 'Login
failed for user 'sa' because the account is currently locked
out'. IN OTHER WORDS, YOU HAVE TO SAVE YOUR MODIFICATION,
UPLOAD IT AT THE NEXT LOGIN.

Answer / visala

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.

Answer / raj kumar

Wnidows Authentication
1.Single User can only login
2.Not Integerated
3.Not Security

SQL Authentication
1.Multi user can login
2.Integerated
3.More security

Answer / hari

Windows authentication is more securable compare to mixed
mode authentication.

Answer / 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.

Answer / oipweuroiu

both are same

which table keeps the locking information? : Sql server administration

0 Answers  

Do you know exporting and importing utility?

0 Answers  

How to drop an existing table?

0 Answers  

After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,

What is mean by dml?

0 Answers  

What is sql server 2000 work load governor?

0 Answers  

How column data types are determined in a view?

0 Answers  

What are the four main query statements?

7 Answers   Wipro,

How would you use user_constraints table in DB?

0 Answers   Wipro,

What are translations and its use? : sql server analysis services, ssas

0 Answers  

What new changes are being made in SQL Server?

0 Answers   Blue Star,

Why does sql studio use a single registered database repository? : sql server management studio

0 Answers