asked
SQL SERVER OVER SSH
Hello . I need some help please. We have a client server desktop application running in our LAN , or VPN. For some security issue the server is in another city , and the client application connect through a vpn with real ip. We need to encrypt the channel communication with SSH. We need to implement in but a can understand . I have research in google but i can understant the configuration. The situate is this: ip of server : 10.10.10.1 lisen in port 1440. the client application have range ip L 192.168.1.100 --> 192.168.1.150 . How to implement SSH in client and server. The application is a desktop application . please help me .
(Assuming SSL, rather than SSH...) This is explained in some detail in Denny Cherry's book on [Securing SQL Server][1]. Denny's speaking on Securing SQL Server at [SQL Saturday in Exeter in the UK][2], happening soon. Disclaimer: I only read this for the first time yesterday, and my head was melting. Summary: * Certificate, stored in either local computer cert store, or SQL Server user account cert store * SQL Server Configuration Manager, Protocols, properties - add certificate, then force encryption. You might want to hide the instance too. * Configure IPSec (probably easiest done at the domain level) There's pages and pages of stuff (discussion, screenshots etc) in Denny's book - get it, read it, talk through it with your network admin, and try it all out in a non-production environment first. [1]:
http://www.amazon.com/gp/product/1597499471 [2]:
http://www.sqlsaturday.com/194/eventhome.aspx
10 People are following this question.
