PrepAway - Latest Free Exam Questions & Answers

Tag: sql server accounts

What should you do to all SQL servers to provide maximumsecurity for login accounts?

You are the SQL administrator for your company. A SQL Server 2008 computer named VMSQL01 is configuredwith the following settings on the Security page of the
Server Properties dialog box:

A new security policy has been adopted by your company that requires all SQL servers to provide maximumsecurity for login accounts. Backward compatibility should not be a consideration. exhibit What should you do?