Data Encryption
-
What would be the best answer?
Q. You are the administrator of SQL Server computers. One server is named SQL7, and other is named SQL2000. SQL7 is running SQL Server 7.O and SQL2000 is running SQL Server 2000.
SQL7 is configured so that it has the named pipes, TCP/IP, NWlink, IPX/SPX and multiprotocol Net Libraries.
SQL2000 and SQL7 exchange confidential company information.
You need to ensure that unauthorized users cannot access this information.
Which two actions should you take? (Choose two)
A. On SQL2000, enable the multiprotocol net library.
B. On SQL2000, select the force protocol encryption check box.
C. On SQL7, select the force protocol encryption check box.
D. On SQL2000, install a secure sockets layer (SSL) encryption certificate.
E. On SQL2000 and SQL7, enable multiprotocol encryption.
-
So as not to turn this into a braindump, let's take the following approach: you tell us what answer you would have chosen and why. The key point is to understand WHY the answer is what it is, not just rote memorize something.
There are many knowledgeable people at SSC who can answer this question and one of 'em will come along and look at your answer. If there's a flaw in your thinking, that'll assist them greatly in identifying what it is. Likewise, if you have reasoned the correct answer properly, you'll get reinforcement on that.
K. Brian Kelley
@kbriankelley -
As Brian already said, one might be inclined to think that this is a test question, you should really answer yourself. It will yield you nothing, if you can provide the correct answer, but don't know why.
Btw, Brian, nice new homepage.
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
The most information I have found in the SQL Server Books Online is
under Using Encryption Methods, Data in Network Packets.
"For compatibility with earlier versions of SQL Server, the
Multiprotocol Net-Library continues to support its own encryption.
This encryption is specified independently of the SSL encryption and
is implemented by calling the Windows RPC encryption API."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply