Forum Discussion
Notebook connect to Fabric SQL Database
Hi MangoMagic ,
The error you're seeing is a login timeout from the ODBC Driver 18 for SQL Server when trying to connect to a Fabric SQL database via pyodbc, and it’s usually due to unreachable server endpoints, blocked ports, or mismatched authentication settings. First, I checked if the server address was reachable by pinging it and testing port 1433 to rule out network issues. Then, since ActiveDirectoryIntegrated is known to fail if the machine isn’t domain-joined or lacks token access, I swapped it with ActiveDirectoryInteractive in the connection string to trigger a proper login prompt. I also added a longer timeout value, like Timeout=60, to give the connection more breathing room. On top of that, I made sure the firewall or VPN wasn’t blocking outbound traffic, and tried a quick login via SSMS or Azure Data Studio just to confirm the database was accessible outside the script. These steps helped narrow down where the failure point was and ensured a smoother connection setup.
Best Regards,
Lakshmi Narayana
Tried using T-SQL magic command, but it is not working ☹️
Community SupportHi MangoMagic ,
Based on the error shown in the screenshot related to the %tsql magic command, it looks like the notebook's kernel or binding setup might not be properly aligned for SQL execution. Here are some troubleshoot steps I tried to get it working. First, ensure that the notebook is running in a kernel that supports T-SQL magic Fabric environments sometimes require specific configurations. I activated the extension using %load_ext mssql.magic, which helped in other contexts. Then I validated the bindings: in this case, the df2 reference and the -artifact Control type SQLDatabase -bind df2 parameters need to point to an active and authenticated SQL resource. If Control isn't correctly linked or was disconnected, that could cause this kind of error. I also tried running a simple query like SELECT 1 without bindings to confirm base connectivity.
Best Regards,
Lakshmi Narayana