I have been trying to connect to the server on Microsoft SQL Management Studio using Workbench via an IP.
But I cannot seem to connect whatsoever, is workbench even supported with Database engine servers.
I am connecting with the root username, could that be the problem too?
CodePudding user response：
If you are referring to MySQL Workbench and SQL Server, MySQL is a visualization tools for MySQL Server and databases. You cannot access other servers with it. SSMS or SQL Server Management studio is the visualization tool for SQL Server databases. These both databases use almost similar syntax and structure but are totally different entities in terms of Parent Company and access.
In Layman's terms, when you try to enter an IP in Workbench, it tries to find and access a MySQL Server but doesn't find it and hence does not connect. It is not a SSH Client which connects to any server specified.
There is one way to connect SQL Server from MySQL Workbench and that is database miration.
I recommend SQL Server Management Studio for SQL Server Access and visualization.
CodePudding user response：
For connecting to SQL Server using Python, consider PyODBC (preferred) or pymssql as documented here