Error on using Cache Notifications on SQL Server 2008

Hallo,

I wanted to use cache notification with sql Server 2008 in my application. Unfortunaly I got the following error:

System.Web.HttpException: Unable to connect to the SQL database for cache dependency registration. ---> System.Data.SqlClient.SqlException:
Login failed for user ...

I think the problem is to enable notification on the server. How can I enable it for my database on the server?

 

I found the problem: the pasword was missing in the ConnectionString of the query object.

SqlCacheDependencyAdmin.EnableNotifications(query.Context.Connection.ConnectionString);

It´s taken from the Web.config, but without the password. Unfortunatelly I don´t know why. However it´s solved.

 

Thanks for the follow-up post.