Environment : SharePoint 2010.
Description: I am trying to create new web-application through Central Admin. Once I click on '
New' I am getting below error.
Verified below based on this article
- Login to the MSSQL Server Management Studio with Windows Authentication.
- In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
- Under the Server Properties, select a page of "Security".
- Select the Server authentication as "SQL Server and Windows Authentication mode" and click Ok.
In event viewer I got found below error:
SQL database login for 'master' on instance 'devsp01' failed. Additional error information from SQL Server is included below.
Login failed for user 'sa'.
In SQL Server I can see '
sa' account under Security -> Logins
What could be possible reason?
What all things I need to verify?
Edit: After digging more I found below error message in event viewer.
Login failed for user ‘sa’. Reason: Password did not match that for the login provided. [CLIENT: ]
But I wonder, there is no change in password.