70-450 · Question #22
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…
The correct answer is B. Kerberos authentication. Kerberos is also supported with Named pipes protocol: Very good discussion about this: 922f90ecd8ea4384/
Question
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 isntance 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?
Options
- ANTLM authentication
- BKerberos authentication
- CSQL Server authentication
- DMixed-mode authentication
How the community answered
(36 responses)- A14% (5)
- B75% (27)
- C3% (1)
- D8% (3)
Explanation
Kerberos is also supported with Named pipes protocol: Very good discussion about this: 922f90ecd8ea4384/
Topics
Community Discussion
No community discussion yet for this question.