SqlSiteMap provider

Discussion in 'Databases' started by Fiontan, Mar 21, 2007.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Fiontan

    Fiontan

    Greetings all.
    i uploaded a new site recently that uses the SQL Site Map Provider. When I request a page accessing the map provider I get the following:

    The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.

    This is prevented by removing the part of


    <add name="AspNetSqlSiteMapProvider" type="SqlSiteMapProvider" securityTrimmingEnabled="true" connectionStringName="R2Bars" />


    but if you need the functionality ...any ideas?


    Fiontan
     
    Fiontan, Mar 21, 2007
    #1
  2. vvsharma

    vvsharma

    Try :
    ALTER DATABASE your_db_name SET ENABLE_BROKER

    Vikram

    DiscountASP.NET
    www.DiscountASP.NET
     
    vvsharma, Mar 21, 2007
    #2
  3. JorgeR

    JorgeR DiscountASP.NET Staff

    Please make sure that when the statement:

    ALTER DATABASE your_db_name SET ENABLE_BROKER

    is issued, you will need to make sure that the database is in single_user mode:

    ALTER DATABASE your_db_name
    SET SINGLE_USER WITH ROLLBACK IMMEDIATE

    Service broker is available on the express version:
    select is_broker_enabled from sys.databases where [name] = 'your_db_name'


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Dec 20, 2007
    #3
  4. GregT

    GregT

    GregT, Dec 20, 2007
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page