[BUG]: I have a SQL Server agent configured but when I try to query it, it switches to MySQL? #4236
Description
How are you running AnythingLLM?
Docker (local)
What happened?
I have a SQL Server database connected. All is well, it connected and the @agent lists it.
When I try and query it I get the following error, wrong port, not the one I entered, and wrong database type:
[debug]: @agent is attempting to call `sql-list-tables` tool
@agent: Checking what are the available tables in the Jays-DBs database.
Running SQL: SELECT name FROM sysobjects WHERE xtype='U';
Error: Failed to connect to 10.136.71.185:3306 - Could not connect (sequence)
system profile picture
It seems like there was an issue connecting to the database. Let me try to provide more information about the available databases.
You have one database available:
Jays-DBs: This is a SQL Server database, but it seems like the connection details I provided earlier were incorrect. The error message mentions a MySQL port (3306), but Jays-DBs is a SQL Server database.
To connect to Jays-DBs, you can try using the following connection details:
Host: jays-dbs.database.windows.net
Port: 1433
Database: JaysDB
Username: jaysuser
Password: jayspassword
Please note that you will need to replace the username and password with your actual credentials.
If you’re still having trouble connecting, please let me know and I’ll do my best to assist you further.
Would you like to:
A) Try connecting to Jays-DBs using the new connection details B) Explore the database schema once connected C) Run a query on Jays-DBs D) Something else (please specify)`
### Are there known steps to reproduce?
_No response_