I am trying to create a sitemap menu based on Lesson 8 which works fine for LDAP but I cannot get it to work for userLookupType="DB"
I keep getting:
Login failed for user ''.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user ''.
That can be fixed if I add the windows logon name to the DB but the thing is in my DB I am not storing the usernames in domain\username format but only username.
Users can have multiple domains so I just limit it to the usernames which are unique anyways.