Page History

...

1. Open the MSPbots Agent client and click the Save Log button on the upper right corner of the window. 
   
2. Click Confirm on the Tips popup that appears. 
    
3. Next, select the location to save the logs, provide a filename, and click Save.
4. Send the file to support@mspbots.ai. 

Frequently Asked Questions (FAQs)

Issue Description:

       The SQL Server encountered an issue of being unable to connect to database.

     Image Added

Solution steps:

1. To download DBeaver, simply follow this link: https://dbeaver.io/download/and install it on the computer where you have installed SQL Agent Client.
2. Launch DBeaver and connect to SQL Server.Image Added
3. Please input your account, password, host and port number. Click Test Connectionand check for any errors.Image Added
4. If an error occurs as shown in the following figure, please perform the following steps.Image Added
5. Please retrieve the port number of your SQL Server through querying.Image AddedImage Added
6. To modify the port number of your SQL Server, please follow these steps:
   1. Click MSPbots> Integrations.
   2. Type 'SQL Agent' in the search box.
   3. Please modify the port number of the SQL Server where the error occurred to match the port number of your SQL Agent.Image Added

      PS:

      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
7. Restart SQL Server to ensure the changes made take effect.

          Image Added