Use SQL Server security

If you are connecting to a remote SQL Server instance, ensure SQL Server is configured to accept Remote Connections.

If you are using a SQL Server account, ensure the SQL Server instance is configured to allow mixed mode authentication.

Link or import data from a SQL Server table using SQL Server authentication.

1. Create a SQL Server user.

2. Configure security on the target table's database.

3. Import or link SQL server tables.