Connection Error Between Azure SQL DB with the codebase.

Question

Connection Error Between Azure SQL DB with the codebase.

SHASWATA DAS 55

I have created a SQL DB in the azure portal, setup it's server and crate a database table using the azure Data studio.

Now I setup a Microsoft Entra ID and add my IP for the smooth connection.

Now when I want to make a connection with my DB, I am facing the issue -
Server running on http://localhost:8080

Database connection failed: ConnectionError

at /Users/shaswatadas/Documents/React Project/authentication-app-by-azure/node_modules/mssql/lib/tedious/connection-pool.js:85:17

at Connection.onConnect (/Users/shaswatadas/Documents/React Project/authentication-app-by-azure/node_modules/tedious/lib/connection.js:838:9)

at Object.onceWrapper (node:events:633:26)

at Connection.emit (node:events:518:28)

at Connection.emit (/Users/shaswatadas/Documents/React Project/authentication-app-by-azure/node_modules/tedious/lib/connection.js:959:18)

at /Users/shaswatadas/Documents/React Project/authentication-app-by-azure/node_modules/tedious/lib/connection.js:2487:18

at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {

code: undefined,

originalError: AggregateError

  at /Users/shaswatadas/Documents/React Project/authentication-app-by-azure/node_modules/tedious/lib/connection.js:2486:31

  at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {

[errors]: [ [ConnectionError], [AggregateAuthenticationError] ]

Can you please help me to figure out the issue?

SSingh-MSFT 16,371 Reputation points Moderator

2024-05-21T08:23:17.5433333+00:00

Hi SHASWATA DAS •,

Welcome to Microsoft Q&A forum.

As I understand, you are getting error in connection to Azure SQL Database from Azure Web App.

Let us know if our understanding of setup is correct.

Could you please check on the firewall rules in Azure SQL Database allow connection from Azure Web App.

Did you configure App service to use Managed Identity?

Thanks
SHASWATA DAS 55 Reputation points

2024-05-21T10:22:51.08+00:00
Hi @SSingh-MSFT ,

Regarding the firewall rules in Azure SQL Database, I have add my client IPv4 address, and also checked the box (Allow Azure services and resources to access this server).

Please let me know if I need other configurations to perform.

And regarding, 'Did you configure App service to use Managed Identity?',
I do not anything in this part, Can you please give some more info about this?

I am sharing the config file with you, it may help you to understand the issue -

const config = { authentication: { type: 'azure-active-directory-password', options: { userName: '******@cloudkaptan.com', // Azure AD username password: 'S**********d', // Azure AD password clientId: '*******************************' // get the value after doing the app register on the Microsoft Entra ID } }, server: 'authentication-db-server.database.windows.net', port: 1433, database: 'authentication-user-db', options: { encrypt: true } };
SSingh-MSFT 16,371 Reputation points Moderator

2024-05-22T05:33:01.05+00:00

Hi SHASWATA DAS •,

Thanks for the reply.

Could you please let us know from where you are trying to access Azure SQL Database?

Which services are involved in the process and what steps are you following so that we can reproduce scenario and check at our end.

Thanks.
SHASWATA DAS 55 Reputation points

2024-05-22T05:58:27.5633333+00:00
Hi @SSingh-MSFT ,

Sorry to inform you late, but I have made some changes and now I am able to connect with the DB from node.js. and answering your question, I am using the SQL database service.

The modifications I have made are -

Microsoft Entra authentication only - I have to check the box as false because I am trying to connect via username and password.

Port issue - Previously I am trying to connect via a port which is closed.

These are some issues that landed me in the issue. But now it is communicating with the DB well and we are good to close the ticket.

Thanks for the support.

Accepted answer

0 additional answers

Your answer

SSingh-MSFT 16,371 Reputation points Moderator

2024-05-21T08:23:17.5433333+00:00

Hi SHASWATA DAS •,

Welcome to Microsoft Q&A forum.

As I understand, you are getting error in connection to Azure SQL Database from Azure Web App.

Let us know if our understanding of setup is correct.

Could you please check on the firewall rules in Azure SQL Database allow connection from Azure Web App.

Did you configure App service to use Managed Identity?

Thanks
SHASWATA DAS 55 Reputation points

2024-05-21T10:22:51.08+00:00

Hi @SSingh-MSFT ,

Regarding the firewall rules in Azure SQL Database, I have add my client IPv4 address, and also checked the box (Allow Azure services and resources to access this server).

Please let me know if I need other configurations to perform.

And regarding, 'Did you configure App service to use Managed Identity?',
I do not anything in this part, Can you please give some more info about this?

I am sharing the config file with you, it may help you to understand the issue -

const config = { authentication: { type: 'azure-active-directory-password', options: { userName: '******@cloudkaptan.com', // Azure AD username password: 'S**********d', // Azure AD password clientId: '*******************************' // get the value after doing the app register on the Microsoft Entra ID } }, server: 'authentication-db-server.database.windows.net', port: 1433, database: 'authentication-user-db', options: { encrypt: true } };
SSingh-MSFT 16,371 Reputation points Moderator

2024-05-22T05:33:01.05+00:00

Hi SHASWATA DAS •,

Thanks for the reply.

Could you please let us know from where you are trying to access Azure SQL Database?

Which services are involved in the process and what steps are you following so that we can reproduce scenario and check at our end.

Thanks.
SHASWATA DAS 55 Reputation points

2024-05-22T05:58:27.5633333+00:00

Hi @SSingh-MSFT ,

Sorry to inform you late, but I have made some changes and now I am able to connect with the DB from node.js. and answering your question, I am using the SQL database service.

The modifications I have made are -

Microsoft Entra authentication only - I have to check the box as false because I am trying to connect via username and password.

Port issue - Previously I am trying to connect via a port which is closed.

These are some issues that landed me in the issue. But now it is communicating with the DB well and we are good to close the ticket.

Thanks for the support.

Answer 1

Hi SHASWATA DAS •,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to "Accept " the answer.

Solution taken in Customer Verbatim:

I have made some changes and now I am able to connect with the DB from node.js. and answering your question, I am using the SQL database service.

The modifications I have made are -

Microsoft Entra authentication only - I have to check the box as false because I am trying to connect via username and password.
Port issue - Previously I am trying to connect via a port which is closed.

These are some issues that landed me in the issue. But now it is communicating with the DB well.

If you have any other questions or are still running into more issues, please let me know. Thank you again for your time and patience throughout this issue.

Please remember to "Accept Answer" if any answer/reply helped, so that others in the community facing similar issues can easily find the solution.

Thanks

Share via

Connection Error Between Azure SQL DB with the codebase.

0 additional answers

Your answer