![]() ![]() If you're using a password to connect, you can skip the last step. It's also helpful to use Pageant to manage your keys. If you are using an SSH key (recommended), you can set it up in the Connection -> SSH -> Auth tab on the PuTTY configuration window. ![]() It's the address of the server you can connect to with SSH, not the address of the SQL server. This should be the domain name or a public IP address. Start PuTTY and enter the hostname and port of your gateway server. The instructions below will work equally well whether you use a password or a key to log into the gateway server. If you're new to PuTTY, try the official documentation ( ) and a guide to creating SSH keys at This is not meant to be a "getting started" guide for using PuTTY. This article assumes you already have a basic familiarity with SSH concepts and use of PuTTY to open SSH connections from Windows. With the proper port forwarding setup, you can connect to your database from anywhere. This will serve as a gateway or makeshift proxy server. All you need is a server in the office which accepts SSH connections and can connect to the SQL Server. There is another way to connect, using PuTTY and port forwarding. But, what if the database is in your office, and you want to access it remotely, but you don't have a VPN? Connecting to a Microsoft SQL Server database isn't too hard, most of the time. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |