Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between windows authentication and
sql server authentication
- 7 Answers
- 24078 Views
- HCL, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 50 Yes | 13 No |
Post New Answer View All Answers
Why is replication required on the sql server?
what is an extended stored procedure? : Sql server database administration
What is a trace frag?
Is INSTEAD OF trigger directly applicable to Table ?
What does top operator do?
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Explain how you can configure a running aggregate in SSRS?
what is a join? : Sql server database administration
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How to create new tables with "select ... Into" statements in ms sql server?
How can we rewrite sub-queries into simple select statements or with joins?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What is resource governor in sql server?
What is the difference between char and varchar2 datatype in sql?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
