[GitHub] [incubator-superset] eugeniamz commented on issue #9475: Cannot connect my superset to sql server.

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

eugeniamz commented on issue #9475: Cannot connect my superset to sql server.
URL: https://github.com/apache/incubator-superset/issues/9475#issuecomment-611218791
 
 
   This are the steps that I used to connect to MS SQL in Azure  : 
   
   1 - URI for MSSQL Azure needs the database name after the user name for example :
   Co
   
   The URI should be mssql+pymssql://UserName@presetSQL:TestPassword@presetSQL.database.windows.net:1433/TestSchema
   
   2- Pass TDS version as parameter. In  "Extra" Section modify engine_parameters as follow :
   {
   "metadata_params": {},
   "engine_params": {"connect_args": {"tds_version": "7.0"}},
   "metadata_cache_timeout": {},
   "schemas_allowed_for_csv_upload": []
   }
   
   @villebro  gave me the tips :) maybe it helps you too. 

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to 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