search

yorek / ssis-dashboard

HTML5 SQL Server Integration Services Dashboard
http://ssis-dashboard.azurewebsites.net/
Apache License 2.0
257 stars 103 forks source link

Unable to start the flask application : Error : pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect)') #36

Closed Raveendiran-RR closed 4 years ago

Raveendiran-RR commented 4 years ago

Hi,

I get this error pyodbc.OperationalError: ('HYT00', '[HYT00] [Microsoft][ODBC SQL Server Driver]Login timeout expired (0) (SQLDriverConnect)')

my config : CONNECTION_STRING = { "main": "DRIVER={SQL Server};SERVER=BPTBLR0135;DATABASE=SSISDB;UID=sa;PWD=***", }

The same error even when I used trustedconnection=yes Regards, RRR

yorek commented 4 years ago

That's a networking or authentication problem. Make sure server BPTBLR0135 is reachable, configured to allow external connections (check firewall settings) and that TCP support is enabled. Is BPTBLR0135 running on-premises or in the cloud?

Raveendiran-RR commented 4 years ago

Thanks Yorek for the reply, However the issue was I had to type the server name as it appears in the SSMS connection(ServerName\SQLInstanceName) and it worked

Regards RRR