I open up SQL Server Management Studio and reset the user password. Try again from DNN, same error.
I try connecting via SQL Server Management Studio. Login failed.
I look in event Viewer and see
Login failed for user 'dotnetnuke'. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: <local machine>]
I open up up SQL Server Management Studio and connect to '.'
I right click the SQL Server 10.50.1600 node and
- Select properties
- Select Security Page
- Under Server authentication change it to 'SQL Server and Windows Authentication mode'
Right click the SQL Server 10.50.1600 node again and select 'Restart' from the sub menu.
Back to the application and login is successful.