Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Secure connection to SQL Server from Perl DBI

by december (Pilgrim)
on May 29, 2009 at 09:29 UTC ( #766829=note: print w/replies, xml ) Need Help??

in reply to Secure connection to SQL Server from Perl DBI


I don't know anything about SQL Server or Windows, but I would be surprised if there wouldn't be a way to enable authentication over secured connections.

The Unix way to solve this problem would be to tunnel the connection over SSH. This is what I do when MySQL or PostgreSQL are bound to the loopback interface without open ports to the outside. You connect to the server with SSH, and the SSH daemon on the server would then forward the connection locally to the right port where SQL Server is running. I'm sure there are versions of SSH for Windows, and perhaps Putty can listen for connections in a server sort of way. I'm sorry I can't help you more I know nothing about Windows software but this is one way you might be able to make it work in a secure manner.

Good luck!

  • Comment on Re: Secure connection to SQL Server from Perl DBI

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://766829]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (1)
As of 2022-01-18 02:40 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (52 votes). Check out past polls.