Which protocols support Kerberos authentication

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Which protocols support Kerberos authentication on SQL Server 2005?

Answer
TCP/IP
Explanation
Only those clients connecting with TCP/IP can use Kerberos authentication.

(Continued on next question...)

Other Job Interview Questions

• You then write a function to use this assembly, but it does not work. What could be the problem?
• In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?
• In which order do you perform an upgrade to SQL Server 2005 for replicated databases?
• In SQL Server 2005, what does the CREATE SERVICE command do?
• In SQL Server 2005, what does instance aware mean for a service?
• With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?
• You have a relatively new SQL Server 2005 and msdb is corrupt. How can you fix this database without a restore? (data loss is acceptable)
• You want to script the execution of an Integration Services package from the command line for use from a Unix scheduler. What utility would you use?
• What should you have applied a patch for by now on your Windows 2003 and XP systems?
• In SQL Server 2000, how can you send an alert without sending a message to the client?
• More...