SiteMap and DB userlookup

Topics: WCF Cache Service
May 17, 2012 at 5:28 PM

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.

May 21, 2012 at 3:41 PM

Does anyone a work around for the issue above? I am a bit stuck on it.

May 21, 2012 at 9:11 PM


please post here your .config file.

Andrea Ferendeles
NetSqlAzMan Project Coordinator
E-mail Web