Login Failed For User

When I hosted an ASP.NET C# project on Windows Server 2012 with IIS, the login failed. Here is the solution.

When I hosted an ASP.NET C# project on Windows Server 2012 with IIS, the below error appeared.

 

Let's learn how to overcome this error. 

Solution

I found the solution for this issue and I would like share with others.

Step 1

While installing SQL, we have to select "Mix Mode Authentication".

Step 2

Include the username, for example - sa and password: abc@123

Step 3

Then, create a table using SQL Server Authentication.

Step 4

Place the connection in web.config file.

<connectionStrings><add name="ABC" connectionString="Data Source=ServerName; Initial Catalog=DataBaseName; User ID=sa; Password=****** " /></connectionStrings>