I had a full stack aplication for my tfc , i am using SQL server from database and Java+Spring boot with angular when tried to deploy and using a action that requires a query in sql server i get this error
2025-01-15T22:18:52.744Z ERROR 1 --- [nio-8080-exec-3] o.h.engine.jdbc.spi.SqlExceptionHelper : The TCP/IP connection to the host DESKTOP-9SKTQTI, port 1433 has failed. Error: "DESKTOP-9SKTQTI. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
2025-01-15T22:18:52.826Z ERROR 1 --- [nio-8080-exec-3] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.dao.DataAccessResourceFailureException: Unable to acquire JDBC Connection [The TCP/IP connection to the host DESKTOP-9SKTQTI, port 1433 has failed. Error: "DESKTOP-9SKTQTI. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".] [n/a]] with root cause
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host DESKTOP-9SKTQTI, port 1433 has failed. Error: "DESKTOP-9SKTQTI. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
I had tcp active, i had a firewall rule to allow 1433 port, i had configured port forwarding in my rooter, and i had activated mix login in sql server, but idk what i need to do more to conect sql server with render this is my url
DB_SQL_SERVER_URL=jdbc:sqlserver://81.43.8.243:1433;databaseName=JurasickPark;encrypt=false;trustServerCertificate=true