Error related to caching

[FarleySoftware]

I added caching to my local SQL Server 2005 database, and edited the web.config file as well as any .aspx pages accordingly. Everything worked fine.

Then, after uploading to the live server, I now get an error:

The 'MyDatabase:tblAppearances' SqlDependency attribute for OutputCache directive is invalid.

SQL cache dependency polling failed for SQL database 'MyDatabase' because of permission problem.

I tried re-running the aspnet_regsql utility, with no luck (first removing caching, then adding again). The error still occurs.

Any ideas where to look?

Farley Software Solutions

http://www.bryantfarley.com

 

[FarleySoftware]

More code as additional info ...

Datasource:

                <asp:SqlDataSource 
                    ID="SqlDataSource1" 
                    runat="server" 
                    ConnectionString="<%$ ConnectionStrings:MyConnectionString %>"
                    SelectCommand="procGetSomeRecords" 
                    SelectCommandType="StoredProcedure"        
                    EnableCaching="true" 
                    SqlCacheDependency="MyDatabase:tblTableName" />

Web.config

      <sqlCacheDependency enabled="true" pollTime="5000">
        <databases>
          <add 
            name="MyDatabase" 
            connectionStringName="ASPNetConnection"/>
        </databases>
      </sqlCacheDependency>
    </caching>

(ASPNetConnection is a valid connection string & it does work)

Farley Software Solutions

http://www.bryantfarley.com

 

[FarleySoftware]

Fixed!

The users whose logins were in the connection strings had to be added to the role aspnet_ChangeNotification_ReceiveNotificationsOnlyAccess.

For some reason this was not an issue on the local server. But now I know!

Farley Software Solutions

http://www.bryantfarley.com