Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-10 : 09:24:23
|
| Jeff writes "I'm looking for a way to ensure safe transfer of sensitive data from my company's local machines which run default instances of SQL Server 2000 to a web host who is running instances of SQL Server 7.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."First, is this the only, best, and easiest method?Second, if this is the method I must use, how do I use it? It appears that I should use the Client Network Utility to enable Multiprotocol suppport, but after that I don't know what to do." |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2001-12-10 : 19:49:17
|
| What about using something like a VPN? That would encrypt the transfer. |
 |
|
|
jm53671
Starting Member
8 Posts |
Posted - 2001-12-11 : 13:51:36
|
| I appreciate the thought. Our shared hosting provider doesn't offer that as an option. Any other ideas? |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2001-12-11 : 15:36:13
|
| Using the Client Network Utility in SQL2K, there is a check box on the General tab called "Force Protocol Encryption". I don't have the SQL 7 client utility but I'm pretty sure it's the same. I think you can possibly set encryption on an individual alias as well.Try digging through Books Online again under "encryption", there's more info but it's scattered throughout several links. Check them all out thoroughly. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2001-12-11 : 16:47:29
|
quote:
Using the Client Network Utility in SQL2K, there is a check box on the General tab called "Force Protocol Encryption". I don't have the SQL 7 client utility but I'm pretty sure it's the same.
Yes it is the same on SQL 7. I just looked at it. (wondered what that was for... )-------------------It's a SQL thing... |
|
|
|
jm53671
Starting Member
8 Posts |
Posted - 2001-12-13 : 14:06:29
|
| Thanks to everyone for the advice |
|
|
|
|
|
|
Encryption Between SQL 2000 and SQL 7