Process-Automation-with-ASP.NET-Core-Microservices icon indicating copy to clipboard operation
Process-Automation-with-ASP.NET-Core-Microservices copied to clipboard

Cronjobs database fails for dealers microservice

Open stefanMinch3v opened this issue 4 years ago • 0 comments

If I try to navigate to page "Profile" on the website I get exception. After looking at the container's logs I found this error: Unhandled exception. Microsoft.Data.SqlClient.SqlException (0x80131904): Login failed for user 'sa'.

This comes when we try to dinamically create database - CarRentalDealersCronJobsDatabase: image

Solution:

  • Set Integrated Security=false explicitly in that connection string, this way we force user id and password to be used as default authentication. Source - https://docs.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?redirectedfrom=MSDN&view=dotnet-plat-ext-5.0#System_Data_SqlClient_SqlConnection_ConnectionString

stefanMinch3v avatar Dec 06 '20 19:12 stefanMinch3v