[GitHub] wangym1993 opened a new issue #6735: Superset Connection to MS SQL Server Failed. URI Worked on python console

[GitBox <gi...@apache.org>]

wangym1993 opened a new issue #6735: Superset Connection to MS SQL Server Failed. URI Worked on python console
URL: https://github.com/apache/incubator-superset/issues/6735
 
 
   Make sure these boxes are checked before submitting your issue - thank you!
   
   - [X] I have checked the superset logs for python stacktraces and included it here as text if there are any.
   - [X] I have reproduced the issue with at least the latest released version of superset.
   - [X] I have checked the issue tracker for the same issue and I haven't found one similar.
   
   
   
   ### Superset version
   0.28.1
   
   
   ### Expected results
   I am expecting database connection is ok. 
   
   ### Actual results
   
   I encountered an issue when adding a ms sql server to superset. I tried all the hints or solutions on Stack overflow and on here. Nothing works for me. I am using Windows and run the server under development. 
   
   The URI I am using is` 'mssql://@SERVER/DATABASE?driver=ODBC+Driver+13+for+SQL+Server'`.  Its weird that when I put the same URI in Python console to create engine using sqlalchemy.create_engine(URI), it works perfectly. It doesn't work when I put the URI in Adding database through Superset. 
   
   `sqlalchemy.exc.OperationalError: (pyodbc.OperationalError) ('08001', '[08001] [Microsoft][ODBC Driver 13 for SQL Server]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].  (-1) (SQLDriverConnect); [08001] [Microsoft][ODBC Driver 13 for SQL Server]Login timeout expired (0); [08001] [Microsoft][ODBC Driver 13 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. `
   
   
   ### Steps to reproduce
   
   
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org