Error connecting SQL Server 2000

[claudionoronhafilho]

Hello. Has anyone here used Budibase with Microsoft SQL Server 2000? I configured the connection to the database, but when I try to fetch the tables, I get a connection error message. I've already tested the connection using python code and also through SQL Server Management Studio and it connects normally.

The error message I get is:

Error updating datasource schema : ConnectionError: Failed to connect to sbs-sql-server:1433 - getaddrinfo ENOTFOUND sbs-sql-server

[andz-bb]

Hi Claudio, from reading #7273 I believe that MS SQL Server 2000 should be supported by Budibase but I don't have an instance to test it on my end. Have you had the chance to try any more recent versions of SQL Server with Budibase? When you try to fetch the tables do you get a more detailed error message in your browser's console or network tab in developer tools? Thanks

[claudionoronhafilho]

Hello @andz-bb . Thanks for your answer

I also tried with SQL Server 2019 and the same error occurs. Below the console logs.

---

index.d953a9aa.js:377 POST http://localhost:10000/api/datasources/datasource_plus_9327deda28344e71888fd27a7bad9518/schema 500 (Internal Server Error)
l @ index.d953a9aa.js:377
(anonymous) @ index.d953a9aa.js:377
buildDatasourceSchema @ index.d953a9aa.js:377
updateSchema @ index.d953a9aa.js:377
T @ index.d953a9aa.js:406
G @ index.d953a9aa.js:23
(anonymous) @ vendor.6bcafa60.js:4
bQ @ vendor.6bcafa60.js:4
T @ index.d953a9aa.js:14
(anonymous) @ vendor.6bcafa60.js:1
index.d953a9aa.js:1 [Builder] HTTP 500 on POST:http://localhost:10000/api/datasources/datasource_plus_9327deda28344e71888fd27a7bad9518/schema
ConnectionError: Failed to connect to growz:1433 - getaddrinfo ENOTFOUND growz
TE.console.warn @ index.d953a9aa.js:1
onError @ index.d953a9aa.js:377
(anonymous) @ index.d953a9aa.js:377
await in (anonymous) (async)
buildDatasourceSchema @ index.d953a9aa.js:377
updateSchema @ index.d953a9aa.js:377
T @ index.d953a9aa.js:406
G @ index.d953a9aa.js:23
(anonymous) @ vendor.6bcafa60.js:4
bQ @ vendor.6bcafa60.js:4
T @ index.d953a9aa.js:14
(anonymous) @ vendor.6bcafa60.js:1

Follow the screens with the errors

[andz-bb]

hey @claudionoronhafilho, thanks for the detailed reply! I'm thinking your value for Server maybe isn't right, it needs to be a valid IP or domain here. What are the details you use when you connect using SQL Server Management Studio?

[claudionoronhafilho]

Hi @andz-bb SQL Server is installed locally. Even using the local IP (192.168.1.3), the same error appears on the computer where it is installed. Here's a screenshot of SQL Management Studio.

[claudionoronhafilho]

Hi @andz-bb . Good news. I was successful in connecting SQL Server 2008. I needed to enable access via TCP in SQL Server and free the port on the firewall. Now I'm able to access both locally using the internal IP, and externally using ngrok.

I will try the same with SQL Server 2000 which is the DB I need to access.