MS SQL Server Data source New Connection - Failure on SELF HOSTED redash

Can some one help on resolving the below error. Appreciate your help!!!

Issue Summary

MS SQL Server Enterpise 2014 64bit
Data source New Connection - Failure on SELF HOSTED redash

Technical details:

  • Redash Version: 8.0.0+b32245
  • Browser/OS: Chrome/ Windows 10
  • How did you install Redash: Docker

I am able to connect to SQL Server from my laptop where i am trying to access redash (localhost:5000) but not able to connect to the datasource.

Error : Connection Test Failed o

Can someone please provide information on whether redash supports Microsoft SQL Server data setup.

DataSource: Microsoft SQL Server
TDS Version: Left Blank
Character Set : Left Blank
Database name: qa_gpom_db (this is the database data resides)
Server: WNSQL024Q01 (DB Server where qa_gpom_db resides)
Username: TD_Reporting (Login username used to access SQL Server Management Studio or any other data extraction tools)
Password: *******
Port: 1433

Saved and when clicked on Test Connection .
Error: Connection Test Failed 0

@dietdrpepper @arikfr Could you please confirm if “Microsoft SQL Server is support on Self Hosted Redash”.
Appreciate your help on this

Yes, MSSQL is supported on Open Source.

You should add a port-forwarding rule to your Docker script. Without one, when Redash connects to localhost:5000 it’s pointing back into the Docker container which isn’t running a server :frowning: The port-forwarding rule should pass traffic from your Docker container back to your host computer.

Thank you very much for the information. Could you please help where i should put this details in the docker-compose.yml file and do i need to run any command in docker (command prompt).

Here is the content of yml file:

version: "2"
x-redash-service: &redash-service
  image: redash/redash:latest
  depends_on:
    - postgres
    - redis
  env_file: redash.env
  restart: always
services:
  server:
    <<: *redash-service
    command: server
    ports:
      - "5000:5000"
    environment:
      REDASH_WEB_WORKERS: 4
  scheduler:
    <<: *redash-service
    command: scheduler
    environment:
      QUEUES: "celery"
      WORKERS_COUNT: 1
  scheduled_worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "scheduled_queries,schemas"
      WORKERS_COUNT: 1
  adhoc_worker:
    <<: *redash-service
    command: worker
    environment:
      QUEUES: "queries"
      WORKERS_COUNT: 2
  redis:
    image: redis:latest
    restart: always
  postgres:
    image: postgres:latest
    env_file: redash.env
    restart: always
  nginx:
    image: nginx:latest
    ports: 
      - "80:80"
    depends_on:
      - server
    links:
      - server:redash
    restart: always

Able to fix the issue by just using IP Address of the SQL DB Server instead of DNS Name as Server Name.

Thanks for all the support

1 Like

Nice! Thanks for sharing your solution.