How to use SQL within Noteable plugin notebook and to set up external data connections to “Microsoft SQL Server Management Studio?
should it be connected to any Database which is on cloud ?If so, which server do you recommend?
I have tried connecting to the SSMS the way you described in the detailed guidance.
Unfortunately I am running into some trouble connecting to my Microsoft sql server in Noteable.
Receiving the next Error:
**Operational Error: (pyodbc .Operational Error) (‘HYT00’, ‘[HYT00] [Microsoft][ODBC Driver 18 for SQL Server]Login timeout expired (0) (SQL Driver Connect)’)
I have tried all troubleshooting through google and ChatGpt itself.
After a while, through pinging in the command prompt, I found out that my server is not reachable.
My server name is “[device]\SQLEXPRESS” which I am trying to connect through “[router-public-IP-address][device]\SQLEXPRESS” on port 1433.
The credentials I’m using are the login I use to connect to the server in the management studio.
My firewall has all the IP addresses including the port open.
I forwarded the port in my router as well.