How to Connect to SqlServer RDS with a AWS AMI HVR hub image

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #18141
    Donna Zehl
    Keymaster

    How to Connect to SqlServer RDS with a AWS AMI HVR hub image

     

    Description: 

     

    The problem is that the HVR AMI doesn’t work out of the box because the SQL Server ODBC driver is not bundled with this package due to licensing restrictions. The Unix ODBC 2.3.1 drive is required to communicate with the SqlServer database unfortunately the installation cannot be found in the Amazon Linux package repository and therefore it cannot be installed with a simple “sudo yum install”. Instead it has to be downloaded and installed by you.

     

    Tag: 5.5;

     

     

    Details:

     

    Here are the steps to download and install on your AWS HVR hub.

     

    1. Create a temporary folder on your hub machine for example in the /tmp folder

     

    $ mkdir /tmp/odbc

    $ cd /tmp/odbc

     

    1. Download the Unix ODBC and SQL Server ODBC packages:

    $ wget  http://mirror.centos.org/centos/7/os/x86_64/Packages/unixODBC-2.3.1-11.el7.x86_64.rpm

    $ wget  https://packages.microsoft.com/rhel/7/prod/msodbcsql17-17.3.1.1-1.x86_64.rpm

     

    1. Install both packages:

     

    $ sudo yum install unixODBC-2.3.1-11.el7.x86_64.rpm

    $ sudo yum install msodbcsql17-17.3.1.1-1.x86_64.rpm

     

    1. Create a symbolic link from libodbc.so.2 library to libodbc.so.1

     

    $ cd /usr/lib64

    $ sudo ln -s libodbc.so.2 libodbc.so.1

     

    1. and make sure you add your hub’s private IP address to the RDS instance’s security group then you should be all set.

     

     

Viewing 1 post (of 1 total)
  • The forum ‘How to’ is closed to new topics and replies.

© 2020 HVR

Test drive Contact us