How to Enable SqlCacheDependency

See more:

C#

ASP.NET

SQL

server

I try to enable sqlCacheDependency for my table tblemployee..

Like this format: C:\Windows\Microsoft.NET\FrameWork\v2.0.50727>aspnet_regsql.exe -E -d Milton -et -t tblemployee

--------------------------------------
On that time I got error below.

Enabling the table for SQL cache dependency.

...............An error has happened. Details of the exception:
A network-related or instance-specific error occurred while establishing a conne
ction to SQL Server. The server was not found or was not accessible. Verify that
the instance name is correct and that SQL Server is configured to allow remote
connections. (provider: Named Pipes Provider, error: 40 - Could not open a conne
ction to SQL Server)

Unable to connect to the SQL database for cache dependency registration.


Please help me.