Login failed on a site on ASP + MS SQL Server?

Question

ASP.NET

There is a site (one training page), deployed. It works until there is no interaction with the MS SQL database. That is, when you need to read data from there, a login failed error occurs. But if you test from a local machine from Visual Studio, it works.
What could be the problem? Accesses in MS SQL SERVER are registered for the user through which the connection to the site is made

Answer 1

Your web application must have a DefaultConnection with a username and password. This user must have access rights to this database.