

Get in touch

Download Plugin Now
  • Follow
  • Follow
WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
a
M
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
    • Tool Guide
    • App Builder
    • Data Explorer
    • SQL Query Builder
    • Plugin Settings
    • Legacy Tools
    • Remote Connections
Download Plugin Now

Remote Databases

  • MySQL | MariaDB
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
  • WordPress user ID in SQL

Premium Data Services

  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Overview
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
  • Remote Data Files
    • Overview
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
  • Advanced features
    • Performance
    • Indexes
View Categories

Connect to SQL Server

WP Data Access supports connections to Microsoft SQL Server over ODBC and JDBC. Please follow the link below to learn how to setup a connection to SQL Server over ODBC or JDBC first.

  • ODBC | JDBC setup and installation (read this first)

Tutorial #

Step by step #

  1. Check prerequisites
  2. Check architecture
  3. Install CONNECT storage engine (if not installed)
  4. Install ODBC or JDBC drivers
  5. Prepare SQL Server connection (must use SQL Server Authentication)
  6. Check SQL Server table structure (all data type supported? primary key needed?)
  7. Use SQL Server in Data Tables
  8. Use SQL Server in Data Projects (supports data management on the back-end and front-end)

Resources #

  • https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server
  • https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server
Share This Article :
  • Facebook
  • X
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2025-02-07

8 Comments

  1. Arslan Arif
    Arslan Arif on 2021-09-28 at 12:15 am

    Hey Peter,

    Awesome plugin. Will the remote connection functionality work with Microsoft Azure SQL Database? We have the option of choosing between Microsoft Azure SQL Database and Microsoft Azure SQL Server. We prefer to use the Azure SQL Database because less administrative overhead and cost of ownership. Our WordPress database is Percona Server (SSO Sigon) and I don’t believe we have a remote MariaDB database connection setup. Is the remote connection functionality still a viable option for us to connect to Microsoft Azure SQL Database/Server?

    Best Regards,
    Arslan

    Reply
    • Peter Schulz
      Peter Schulz on 2021-09-28 at 12:47 pm

      Hi Arslan,

      That is an interesting question! 🙂 I have never tested with Azure, but ODBC and JDBC are supported by MariaDB and Azure, so it should be possible. Is this something we can pickup together?

      Best regards,
      Peter

      Reply
  2. sandy verfaille
    sandy verfaille on 2022-01-02 at 9:31 pm

    Hi Peter,

    Awesome plugin you made.
    I’m running this website http://www.inksaneartists.com, and I would love to have it read data from a remote microsoft SQL server db.
    My wordpress plugin is using MySql and not MariaDB.
    So i’m trying to follow your videotutorial, where you make a gateway to a mariadb first.
    But here I’m stuck..
    Obviously copying the same data that you put in is not working. Since you are using a personal IP.
    Should I first go make a mariadb somewhere else (with my current hosting provider?), and then have WP Data Access connect to that?
    Or where can I find the IP that does work for my installation? What am I missing?

    Thanks already!

    Reply
    • Peter Schulz
      Peter Schulz on 2022-01-03 at 5:28 pm

      Hi Sandy,

      To use your SQL Server tables from your WordPress server, your MariaDB database needs to be reachable from your WordPress server and your SQL Server needs to be reachable from your MariaDB server. The MariaDB server acts as a proxy. Your MariaDB and SQL Server databases will usually be on the public network both, and you need to be able to establish a remote connection.

      Hope this helps,
      Peter

      Reply
  3. Jimmy
    Jimmy on 2022-01-31 at 9:29 pm

    Hello,

    Is this possible to connect to remote SQLite database?

    Regards,
    Jimmy

    Reply
    • Peter Schulz
      Peter Schulz on 2022-02-01 at 12:44 pm

      Hi Jimmy,

      You can use JDBC or ODBC to connect to a remote SQLite database (I have not tested this!). You should carefully read this page before you start:
      https://wpdataaccess.com/docs/heterogeneous-connections/odbc-jdbc/
      Additionally you need to download the necessary drivers and call them in your table definition.

      You can follow the steps as described in the video on this page, you just need to change the connection parameters. The correct parameters should be documented with your driver.

      Hope this helps,
      Peter

      Reply
  4. Robert Jones
    Robert Jones on 2022-12-28 at 11:06 pm

    Peter, I also am interested in connecting to a Microsoft SQL Server. Isn’t there a way now to connect directly rather than use MariaDB as a proxy?

    Reply
    • Peter Schulz
      Peter Schulz on 2022-12-30 at 1:11 pm

      Hi Robert,

      It is possible to connect directly to SQL Server from WP Data Access, but only if you run MariaDB and have full OS admin access. You can find more information here: https://wpdataaccess.com/docs/remote-database-connections/connect-to-sql-server/

      It is generally possible to connect to SQL Server, but our API is MariaDB|MySQL based, the reason why we route through MariaDB. Connecting directly would require DBMS specific classes for each supported DBMS. Maybe something for the far future…

      Hope this helps,
      Peter

      Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • Tutorial
  • Step by step
  • Resources
WP Data Access
  • Follow
  • Follow
Links
$

Imprint

$

Privacy policy

$

Cookie policy

Get in touch
$

Contact us

$

Free support forum

$

Premium support

Resources


WordPress plugin directory



YouTube tutorials

Copyright © 2025 | All Right Reserves

Manage Consent
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about these purposes
View preferences
{title} {title} {title}