How to configure the account EntLib uses for Caching database

Aug 20, 2008 at 1:55 PM
I followed setup guide for FS_2.5 Beta, but the web part shows "not cached", ever when the caching is enabled.
When I looked at SQL Server log, there was the following event

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: (4)
Event ID: 18456
Date:  20.08.2008
Time:  15:30:19
User:  NT AUTHORITY\ANONYMOUS LOGON
Computer: (SQL Server)
Description:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: (IP Address of Sharepoint Server)]

How to configure the account under which EntLib should access Caching database? Which permissions needs this account in the Database itself?

Coordinator
Aug 20, 2008 at 2:21 PM
The Caching and Data Access security requirements are documented in the Enterprise Library docs.
On MOSS side access normally depends on your deployment topology and chosen authentication. For starters I'd suggest to grant MOSS web app pool account a datawriter access to the Caching database. Please continue posting your findings on this topic.