question

erjon avatar image
erjon 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 .
sql-server-2008-r2security
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
(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 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.