Fix for new sqlserver pipeline error - Githubissues

Datavault-UK / automate-dv

A free to use dbt package for creating and loading Data Vault 2.0 compliant Data Warehouses (powered by dbt, an open source data engineering tool, registered trademark of dbt Labs)

https://www.automate-dv.com

Apache License 2.0

511 stars 131 forks source link

Fix for new sqlserver pipeline error #161

Closed DVTimWilson closed 2 years ago

DVTimWilson commented 2 years ago

2022-10-12T09:28:21.2704805Z Connection:
2022-10-12T09:28:21.2705147Z   server: localhost
2022-10-12T09:28:21.2705516Z   database: DBTVAULT_DEV
2022-10-12T09:28:21.2705858Z   schema: TEST
2022-10-12T09:28:21.2706200Z   port: 1433
2022-10-12T09:28:21.2706533Z   UID: dbt_user
2022-10-12T09:28:21.2706874Z   client_id: None
2022-10-12T09:28:21.2707214Z   authentication: sql
2022-10-12T09:28:21.2707565Z   encrypt: True
2022-10-12T09:28:21.2707910Z   trust_cert: False
2022-10-12T09:28:21.2708233Z   retries: 1
2022-10-12T09:28:21.2708762Z   Connection test: [[31mERROR[0m]
2022-10-12T09:28:21.2708993Z 
2022-10-12T09:28:21.2709456Z [31m1 check failed:[0m
2022-10-12T09:28:21.2709907Z dbt was unable to connect to the specified database.
2022-10-12T09:28:21.2710381Z The database returned the following error:
2022-10-12T09:28:21.2710607Z 
2022-10-12T09:28:21.2710915Z   >Database Error
2022-10-12T09:28:21.2712085Z   ('08001', '[08001] [Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [error:1416F086:SSL routines:tls_process_server_certificate:certificate verify failed:self signed certificate] (-1) (SQLDriverConnect)')
2022-10-12T09:28:21.2713103Z 
2022-10-12T09:28:21.2713546Z Check your database credentials and try again. For more information, visit:
2022-10-12T09:28:21.2714528Z https://docs.getdbt.com/docs/configure-your-profile

Update deprecated env variable SA_PASSWORD to MSSQL_SA_PASSWORD Add TrustServerCertificate parameter '-C' to sqlcmd calls