Connection Error(s):
Index #: 0
Source: .Net SqlClient Data Provider
Class: 14
Number: 18456
Message: Sql login failed
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.
4 comments:
Or, switch the application pool identity to a domain account and create a new server login. Hurray integrated security!
This is such a great resource that you are providing and you give it away for free. I enjoy seeing websites that understand the value of providing a prime resource for free. I truly loved reading your post. Thanks!
Couldnt agree more with that, very attractive article
Wow this is a great resource.. I’m enjoying it.. good article
Post a Comment