Page History

...

1. Download DBeaver.
2. Install it on the computer where the SQL Agent Client is installed. 
3. Launch DBeaver and connect to the SQL Server.
   
   
4. Enter your account, password, host, and port number. Click Test Connection and check for any errors.
   
5. If an error occurs as shown in the following figure, please perform the following steps.
    
6. Retrieve the port number of your SQL Server through querying.
   
   
7. Follow these steps to modify the port number of your SQL Server.
   1. Click MSPbots > Integrations.
   2. Type SQL Agent in the search box.
   3. Modify the port number of the SQL Server where the error occurred to match the port number of your SQL Agent.
      
      
      
      

      Info
      The Database IP information configuration rules: For SQL Server  Default instance + Default port (1433): IP Default instance + Custom port: IP, XXXX Named instance + Default port: IP\ Instance Name Named instance + Custom port: IP\ Instance Name,XXXX  For My SQL  The Database uses the default port (3306): IP  The Database uses a custom port number: IP;port=XXXX

      
      
8. Restart SQL Server to ensure the changes made take effect.

 What are the states shown in the SQL Agent Integration? 

...