Home Forums Programming Connecting Error trying to connect to a remote mssql database RE: Error trying to connect to a remote mssql database

  • Tatay_2016 (11/25/2016)


    Hi,

    First time here. I'm the admin of a small business with a mssql database that is remotely hosted by our website provider. I need to import/export data to/from a table on the database (which is hosted remotely) into a format where I can manipulate the data.

    I have all the database table and server info and the usr/pwd, and I tried to use the ms excel wizard (the latest version of office 365 on a windows 7 laptop) and it just keeps failing, can't connect.

    So my question: Is there an easier way to connect to a remote sql database from a laptop for data transfer? The workbook wizard seems inadequate, or I'm missing something. I've just started learning this and don't know all that much about other ways to connect to this database to accomplish what I want that don't require a lot of training or programming knowledge.

    Thank you.

    Quick thought, you should contact the provider for connection information, vpn options etc. as normally, a database server would reside behind a firewall.

    😎