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

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

eugeniamz edited a comment 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 :
   User Name : UserName
   Password : TestPassword
   Database : presetSQL.database.windows.net
   Schema : TestSchema
   Port : 1433
   
   
   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