Versions Compared

Old Version 1

changes.mady.by.user Danica Chen

Saved on

compared with

New Version 2

changes.mady.by.user Shindie Linatoc

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Once connected to MSPbots, your SQL Agent will show different states at various times. Each state indicates the current state of your connection with MSPbots and may sometimes require your action.

Below is an example. 

image SQL agent integration statusImage Added

This article lists these states and explains what each means.

What are the different states displayed for the SQL Agent Integration? 

State of IntegrationDescription
"Success"MSPbots is

(The Original Wiki: SQL Agent Integration Setup)

Explanation of Different States Displayed for SQL Agent Integration

The following are explanations of different states under SQL Agent integration.
Image Removed

OrderstateExplanation1SuccessMSPbots has
successfully connected to the SQL Agent.
2
"Your database server connection error, please try again later.
Please try connecting
"There is a connection error. Reconnect to the database server
again later
or check your database server settings and connection.
3
"SqlAgent not connected."The SQL Agent client has not established a connection with the server.
4
"Connect
MSPBots
MSPbots SQL Agent error."The SQL Agent client
has previously
was successfully connected to the server
successfully,
but encountered an error during the connection test.
5
"Please check your User Id or Password, Error."(Original database error message) The
entered
database username or password entered is incorrect.
6
"Please check your Database Name, Error."(Original database error message) The
entered
database name entered is incorrect. 
7
"Please check your IP config, Error."(Original database error message) The
entered
IP address entered is incorrect.
8
"Please check your Database Port, Error."(Original database error message) The
entered
database port entered is incorrect.
9
"Unable to connect to database."The SQL Server is experiencing an issue while connecting to the database. To resolve this problem,
please refer to "
refer to the topic Common Issue: The SQL Server is unable to connect to the database in the article SQL Agent Integration
Setup#FrequentlyAskedQuestions(FAQs)"
Setup.
10
"Warning, Data sync stopped more than 24 hours ago."This state indicates a potential issue with your data synchronization.
Please check
Check your data sync settings and connection as soon as possible to restore
normal
successful data synchronization.