Which authentication method should you use?

You administer a SQL Server 2005 instance. The instance is configured to use the named
pipes network communication protocol. You plan to upgrade the instance to SQL Server
2008. You need to ensure that the upgraded instance can continue to use the named pipes
network communication protocol. You also need to ensure that the server uses the most
secure authentication method available. Which authentication method should you use?

You administer a SQL Server 2005 instance. The instance is configured to use the named
pipes network communication protocol. You plan to upgrade the instance to SQL Server
2008. You need to ensure that the upgraded instance can continue to use the named pipes
network communication protocol. You also need to ensure that the server uses the most
secure authentication method available. Which authentication method should you use?

A.
NTLM authentication

B.
Kerberos authentication

C.
SQL Server authentication

D.
Mixed-mode authentication



Leave a Reply 0

Your email address will not be published. Required fields are marked *