Encrypted connection to SQL 2K?

[hawks67]

Is there such an animal? Or is encrypting the connection something for the Win2K OS to handle?

 

[chiph]

Not to my knowledge. But you could use a VPN connection to do this.

Chip H.

 

[Hal10K]

You can use MultiProtocol. From Books Online, help query was "Encrypt NEAR Protocol", 3 hits and the best one is as follows:

Multiprotocol
The Multiprotocol Net-Library uses the Windows remote procedure call (RPC) facility. With the Multiprotocol Net-Library, unlike other Net-Libraries, configuration parameters are not required.
The Multiprotocol Net-Library:

Communicates over most IPC mechanisms supported by Windows NT. (Only TCP/IP Sockets, NWLink IPX/SPX, and Named Pipes are considered tested and supported.)
Allows the use of Windows NT Authentication over all protocols that RPC supports.
Supports encryption for user password authentication as well as data.
Offers performance comparable to native IPC Net-Libraries for most applications.
To use Multiprotocol encryption for password authentication and data, select Enable Multiprotocol encryption. Multiprotocol encryption is not supported on Windows 95/98.