The following are the error prompts and descriptions you may encounter when creating a dataset and validating the data.
Error Prompts | Description |
"Login Failed For User" |
This indicates that the User ID, Password, and other information you entered for connecting to SQL Agent integration may be incorrect. Please check. |
"Can Not Open Database" |
This indicates that the Database Type, Database Name, and other information you entered for connecting to SQL Agent integration may be incorrect. Please check. |
"No Connection Could Be Made" |
This indicates that the SQL Agent integration may not have connected successfully. Please check. If you need to reconnect, see SQL Agent Integration Setup. |
"Validate SQL Time Out" | This indicates that there is an issue with your SQL. Please optimize your SQL and resubmit. |
"The Server Was Not Found" |
This indicates that the server information you entered for connecting to SQL Agent integration may be incorrect. Please check. |