+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / Web.config error during install "Cannot find NN_NextValue"

Web.config error during install "Cannot find NN_NextValue"

5 posts, 1 answered
  1. Michael Kellogg
    Michael Kellogg avatar
    6 posts
    Registered:
    01 Oct 2009
    12 Apr 2010
    Link to this post
    Configuration Error

    I've just done a new install, using the installer, then set up a database and rights for a new user, then set the new website to run in the Classic ASP.Net app pool.  Then I ran as administrator the website.  I got through the first few screens, but just when I thought it was going to open up my new site, I got this error, which I can't really make heads or tails of:

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Cannot find the object 'NN_NextValue', because it does not exist or you do not have permission.

    Source Error:

    Line 108:        <clear />
    Line 109:        <add connectionStringName="DefaultConnection" applicationName="/"
    Line 110:          name="Sitefinity" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />
    Line 111:      </providers>
    Line 112:    </roleManager>

    Source File: C:\Program Files\telerik\Sitefinity3.7\WebSites\MyTestSite\web.config    Line: 110

    Any ideas on what this is?

    Michael
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    09 Dec 2016
    12 Apr 2010
    Link to this post
    Hello Michael Kellogg,

    Could you run the database server in the context of an administrator/dbo user? It seem that you do not have needed permission to create stored procedures in your database server. We require db_owner role only when you perform database upgrades or when the database is created for the first time.

    If this is the only one stored procedure that fails you could try to create it manually

    USE [TYPE YOUR DATABASE NAME HERE]
    GO
    /****** Object:  StoredProcedure [dbo].[NN_NextValue]   22:52:53 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    ALTER PROCEDURE [dbo].[NN_NextValue](@CounterID nvarchar(50), @CacheSize int)
    AS BEGIN
    update [dbo].[NN_Counters]SET CounterValue = CounterValue + @CacheSize WHERE CounterID = @CounterID
    SELECT CounterValue - @CacheSize + 1 AS CURRENTVALUE, CounterValue AS MAXVALUE
       FROM [dbo].[NN_Counters] WHERE CounterID = @CounterID
    END


    Regards,
    Ivan Dimitrov
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
    Answered
  3. Michael Kellogg
    Michael Kellogg avatar
    6 posts
    Registered:
    01 Oct 2009
    12 Apr 2010
    Link to this post
    Thanks, Ivan.  Changing my site's database user to "dbo" role, then refreshing the page a couple of times, solved it (I'm using SQL Server 2008).  I generally don't like to give such elevated trust especially to an anonymous process like that.  But right now I just want to get this demo rolling.

    -Mike
  4. Kamal
    Kamal avatar
    16 posts
    Registered:
    27 Nov 2010
    07 Dec 2010
    Link to this post
    Hi,

    I have created NN_NextValue stored procedure manually, but still I am getting same error.

    Regards
    Kamal
  5. Radoslav Georgiev
    Radoslav Georgiev avatar
    3370 posts
    Registered:
    01 Feb 2016
    07 Dec 2010
    Link to this post
    Hello Kamal,

    Please review the post before yours. You should grant your db user sufficient permissions to change the db schema and force Sitefinity to perform database upgrade. You can do this by changing the schema version value in sf_DataAccessVariables table and restarting the website.

    Regards,
    Radoslav Georgiev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Register for webinar
5 posts, 1 answered