OT? Access to SQL securely+remotely
-
Setup: SQL 7 sp3, Access 2k
Challenge: connect Access from a wild Internet system to the SQL server, securely (ie, blinding packet sniffers), using SQL authentication, not over a VPN, using only the software that's installed on the average system.
Ok, here's the question - how
I can do all of the above accept secure it. After pouring over MS knowledge base articles and newsgroups, no one seems to be able to answer the question. It seems emminently do-able, there are even overly simple instructions on how to do it with SQL2K. Does this mean that SQL 7 can't?Please help!
TIA,
Oblio
-
Multiprotocol supports encryption and can use TCP/IP, but I'm not sure how feasible it is across the Internet. It's available in SQL Server 7.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Yes, I've heard that before, and it does work fine. However, when I setup a connection that way, it's completely plain text across the Net! If I 'force encryption' or turn on data encryption on the advanced table, I get the error about SECEncryptData().
-
Have you taken a look at this KB article?
http://support.microsoft.com/default.aspx?scid=kb;en-us;239894
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley -
Nope, but I think that's exactly what I need.
Thanks!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply