Replies: 1 comment
-
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;" |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
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
![image](https://private-user-images.githubusercontent.com/111710684/269152663-f4275df3-a340-457e-b895-a966328da1cc.png?jwt=eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJnaXRodWIuY29tIiwiYXVkIjoicmF3LmdpdGh1YnVzZXJjb250ZW50LmNvbSIsImtleSI6ImtleTUiLCJleHAiOjE3MjEyNzk3MTEsIm5iZiI6MTcyMTI3OTQxMSwicGF0aCI6Ii8xMTE3MTA2ODQvMjY5MTUyNjYzLWY0Mjc1ZGYzLWEzNDAtNDU3ZS1iODk1LWE5NjYzMjhkYTFjYy5wbmc_WC1BbXotQWxnb3JpdGhtPUFXUzQtSE1BQy1TSEEyNTYmWC1BbXotQ3JlZGVudGlhbD1BS0lBVkNPRFlMU0E1M1BRSzRaQSUyRjIwMjQwNzE4JTJGdXMtZWFzdC0xJTJGczMlMkZhd3M0X3JlcXVlc3QmWC1BbXotRGF0ZT0yMDI0MDcxOFQwNTEwMTFaJlgtQW16LUV4cGlyZXM9MzAwJlgtQW16LVNpZ25hdHVyZT03ZDZjZDA1YzY2MWNkY2NjMmU0MTk2ODllYTVlNzM0NjdhNGI5NjZhN2ZlMmVhNmIyNWM4Zjg3M2ZhMDk2NmRlJlgtQW16LVNpZ25lZEhlYWRlcnM9aG9zdCZhY3Rvcl9pZD0wJmtleV9pZD0wJnJlcG9faWQ9MCJ9.ECbnAghDTezbel9dqcZSs3zZ5GISkl-2hGkM8Yn3ME8)
Beta Was this translation helpful? Give feedback.
All reactions