hasura / hasura/graphql-engine

SQL Server: Add data source failed `sql server exception`

Open
#6,735 7 comments 2 reactions 0 assignees View on GitHub
a/data/mssql
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

Hi - I was trying out Hasura 2.0 on SQL Server and keep on getting below exception
```
Add data source failed
sql server exception
```
_Details_ button is not really providing any details other than:
```
[
{
"definition": "localtestdb",
"reason": "sql server exception",
"type": "source"
}
]
```
I'm using both Hasura and [SQL Server](https://docs.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash) locally with Docker. And, followed the instructions from [Hasura Docs](https://hasura.io/docs/latest/graphql/core/databases/ms-sql-server/index.html#database-ms-sql-server)

**Database URL**
`Driver={ODBC Driver 17 for SQL Server};Server=localhost,1433;Database=testDB;Uid=SA;Pwd="YoStPw0rd";`

**Image Tags**
- hasura/graphql-engine `v2.0.0-alpha.6`
- postgres `12`
- mcr.microsoft.com/mssql/server `2019-latest`

I also tried to check the Hasura container logs and couldnt find anything useful.
Is there a way to understand more information about the `sql server exception` it is complaining about?
Or if someone else faced the same issue, please share the steps to resolve it..

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.