connection string for database and API on different servers

[sojan1]

Hi
When api and db were on my local i could add the IIS APPPOOL\MauiWebServer under my local database users list.

If my SQL Server database is on one server and my web api is on another, it doesnt

"SqlConnection": "Data Source=SQLSERVERMACHINE\SQLEXPRESS2019; Initial Catalog=CORE; Integrated Security=true;Trusted_Connection=true;TrustServerCertificate=True;MultipleActiveResultSets=False;Encrypt=False"

Error

[sojan1]

If i refresh i dont get error after setting it like below but it still loads with error on initial load.

Adding the user(actually computer name) on SQL Server ->Database ->Security ->New Login with dbo permissions

DOMAIN\DOMAINMACHINE-SRV01$ [IIS Computer Name, not the SQL Server Instance Name]

"SqlConnection": "Data Source=SQLSERVERMACHINE\SQLEXPRESS2019; Initial Catalog=CORE; Integrated Security=true;Trusted_Connection=true;TrustServerCertificate=True;MultipleActiveResultSets=False;"