SQL server SSH proxy



  • DevOps just asked for an ssh server so they can set up a proxy for SQL server. I am having to look this up because I have never heard of it. If anyone has anything they can point me at that would give me an idea of what this is it would be great. Sorry for the low information.



  • You've never heard of ssh or proxy for sql?

    In either case, they said they want to set this up, so just provision Linux server with openssh server installed and have them do the rest of the work.



  • They might be using the term SSH proxy to mean an SSH VPN. Or they might want an SSH jump box, where they log in via SSH, then SSH again to the SQL Server. It's a little ambiguous. But I agree with @marcinozga just install a simple Fedora, CentOS, or Ubuntu server and you are done Tiny VM should do.



  • @marcinozga Thank you so much. They wanted it in 30 min. I said no way. I am going to take your information and get something robust made so if they need it in future I will be able to respond.


  • Service Provider

    @popester said in SQL server SSH proxy:

    @marcinozga Thank you so much. They wanted it in 30 min. I said no way. I am going to take your information and get something robust made so if they need it in future I will be able to respond.

    Thirty minutes is fast, but if you have a standard Linux profile ready, it's not an unreasonable number if it is the highest priority item in the queue.



  • @popester said in SQL server SSH proxy:

    @marcinozga Thank you so much. They wanted it in 30 min. I said no way. I am going to take your information and get something robust made so if they need it in future I will be able to respond.

    You're dealing with DevOps, so getting servers up in minutes is expected. If you run esxi, try this:

    https://communities.vmware.com/docs/DOC-21621



  • @scottalanmiller I am hoping to apply what I have been learning about containers to solve requests like these so they can self serve, and I can be satisfied that it is done securely. In the training I was in yesterday about Ansible there was a lot of talk about what I think of as "traditional" IT department needing to be more agile lest the DEV part of DevOps start forming a shadow IT department. It's a long road and I am looking forward to it.

    Thank you MangoLassi community.


  • Service Provider

    @popester said in SQL server SSH proxy:

    @scottalanmiller I am hoping to apply what I have been learning about containers to solve requests like these so they can self serve, and I can be satisfied that it is done securely. In the training I was in yesterday about Ansible there was a lot of talk about what I think of as "traditional" IT department needing to be more agile lest the DEV part of DevOps start forming a shadow IT department. It's a long road and I am looking forward to it.

    Thank you MangoLassi community.

    Containers really don't add much to this. Traditional VMs do this perfectly well. Nothing wrong with containers, but they are far more limited overall since they need a matching OS underneath them. Find if you are 100% Linux, but the moment you need Windows, it doesn't do much good. Traditional virtualization is the better path in the SMB.