How to put an asp.net application on the server correctly?

Question

ASP.NET

Hello!
Need help with step-by-step instructions on how to properly deploy an asp.net application to the server.
I have windows server 2012/ms SqlServerExpress 2014/IIS I
need instructions on how to properly publish an application from a database .
I have already done:
Created a site in IIS.
The database was copied to SQLServer.
The user for a DB is created.
At this stage, an error appears:

Ошибка входа пользователя "root". 
 Описание: Необработанное исключение при выполнении текущего веб-запроса. Изучите трассировку стека для получения дополнительных сведений о данной ошибке и о вызвавшем ее фрагменте кода. 

Сведения об исключении: System.Data.SqlClient.SqlException: Ошибка входа пользователя "root".

Ошибка источника: 

Необработанное исключение при выполнении текущего веб-запроса. Информацию о происхождении и месте возникновения исключения можно получить, используя следующую трассировку стека исключений.  

Трассировка стека: 

[SqlException (0x80131904): Ошибка входа пользователя "root".].......

But something tells me that initially something was done wrong. If possible, help with advice or a link.

Answer 1

Personally, according to your description, a million questions can be born in me, but oh well. You only need to take a few steps:
1) Publish the project in the Release configuration in order to remove all unnecessary files and get a set of assemblies for the full operation of the application.
2) Deploy the database on the combat server
3) In the configuration files of this application, make sure that all connection strings with the database correspond to the settings of the combat server. If you went to the database under a Windows account, then there is a risk that the system user of the server where your application is running does not have rights to work with the database.
4)Create a site in IIS, specifying the target folder - the folder received when the application was published.