Thanks Flame. I followed the steps in the link you gave. I got to where it prompted for id and password and click next after that but it gives error message as below.
SQL ServerError: 14
[Microsoft][ODSC SQL Server Driver][DBNETLIB]ConnectionOpen (ParceConnectParams()).
SQL Sever Error: 14
[Microsoft][ODSC SQL Server Driver][DBNETLIB]invalid connection.
At the point it promted for Name; Description; and Server, I had used
Wallchart Live Data as name
Optional as Description and
22.214.171.124:1433 as IP.
Please what could be the problem and what should I do.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!