hasura / hasura/graphql-engine

Unable to connect to SQL Server

Open
#7,793 2 comments 0 reactions 0 assignees View on GitHub
k/bug
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

Hi all,
I would like to connect to an on-premises SQL Server 2019 (version 15.0.2000.5 ) using the hasura/graphql-engine:v2.0.10 image.

My connection string is :
Driver={ODBC Driver 17 for SQL Server};Server=tcp:host.docker.internal,1433;Database=BCE;UID=sa;PWD=xxxxx;

I have also installed the ODBC Driver 17 for SQL Server on the Windows box where I start the Hasura docker container, I have downloaded the driver from https://www.microsoft.com/en-us/download/details.aspx?id=56567 (choose the 4.5 MB file).

But when I try to connect to my sql server, I have the following error message
Adding data source failed
Inconsistent object: sql server exception
« Échec de l'ouverture de session de l'utilisateur 'sa' » in french, which means failed to open a session for sa
Many thx in advance
Yan

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.