Can not access local sql server from IIS get error net::ERR_CONNECTION_REFUSED

Question

When running app from Visual Studio 2022, it works fine (connection to sql server). App is an Angular app with a ASP.NET Web API backend.
After running "ng build" and moving distribution files to the server, I can't run the app through the browser.

Extended error from browser:
L
error
:
ProgressEvent {isTrusted: true, lengthComputable: false, loaded: 0, total: 0, type: 'error', …}
headers
:
ue {normalizedNames: Map(0), lazyUpdate: null, headers: Map(0)}
message
:
"Http failure response for https://localhost:40443/api/employees: 0 Unknown Error"
name
:
"HttpErrorResponse"
ok
:
false
status
:
0
statusText
:
"Unknown Error"
url
:
"https://localhost:40443/api/employees"

Any help?

Answer 1

Hi my fried,

Try this: https://support.microsoft.com/pt-br/topic/como-solucionar-problemas-de-configura%C3%A7%C3%A3o-do-iis-no-sql-server-2005-reporting-services-54a19be6-ec79-266a-e2f8-4728d816a78c

Answer 2

I appreciate the response, but it had nothing to do with my original question.

When running my app from the browser, it will not connect to the database (sql server) from IIS. It works very well from within Visual Studio 2022.

I get the net::ERR_CONNECTION_REFUSED error message when it tries to connect to the database.