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

Forums / General Discussions / No Database

No Database

4 posts, 0 answered
  1. Anthony
    Anthony avatar
    108 posts
    Registered:
    29 Sep 2008
    02 Nov 2010
    Link to this post
    I have been creating a website in the Beta version and have about 150 pages created so far. 

    Today when I visit the site I get the "This site is under construction" message.  When I attempt to log into the backend, i am prompted to create a database for the site as if starting from scratch.  The only thing I can think of is that its connection to the Database was lost some how.  I have no idea how this would have happened as I haven't actually logged onto the server in a couple of days.

    I also have another beta site running on the server and it seems to be fine.

    I can see the database on the server and still see all of the Sitefinity tables in it.  Is there a way to reconnect Sitefinity to the DB?  I may go crazy if I have to start over.

    Update:  It seems that the only file in App_Data/Sitefinity/Configuration folder is SecurityConfig.  I do not have the DataCofig, PagesConfig, ProjectConfig, SystemConfig or ToolboxesConfig files found in the other project.

    Is it possible to copy these files from the other project and then modify the connection string to point to the database?

    Anthony
  2. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    02 Nov 2010
    Link to this post
    Hello Anthony,

    Try the following

    1. Open App_Data\Sitefinity\Configuration\DataConfig.config

    2. Set <dataConfig initialized="True">

    3. Set you connection string inside <connectionStrings> node

    <dataConfig initialized="True">
        <openAccessAssemblies />
        <connectionStrings>
            <add name="Sitefinity" connectionString="data source=SERVER;Integrated Security=SSPI;initial catalog=ProjectName" />
        </connectionStrings>


    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
  3. Anthony
    Anthony avatar
    108 posts
    Registered:
    29 Sep 2008
    03 Nov 2010
    Link to this post
    I have done that and changed the SERVER value to the name of the server and ProjectName to the name of the database. 

    going to the site I receive the page under construction page, and when I try to log into the backend I receive the following error.


    Server Error in '/' Application.

    You are not authorized to 'View a page' ('Pages').

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.UnauthorizedAccessException: You are not authorized to 'View a page' ('Pages').

    ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6 and IIS 7, and the configured application pool identity on IIS 7.5) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.

    To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access.

    Source Error:

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

    [UnauthorizedAccessException: You are not authorized to 'View a page' ('Pages').]
       DynamicModule.ns.Wrapped_OpenAccessPageProvider_ab81b0248551443dac385d6e9a5d2b7d.GetPageNode(Guid id) +413
       Telerik.Sitefinity.Web.SiteMapBase.GetRootNodeCore(Boolean ifAccessible) +462
       Telerik.Sitefinity.Web.SiteMapBase.FindSiteMapNode(String rawUrl, Boolean ifAccessible) +652
       Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext) +400
       System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext) +370
       System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context) +75
       System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +80
       System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +266
    


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
  4. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    12 Sep 2017
    03 Nov 2010
    Link to this post
    Hi Anthony,

    There some issue with the permissions of the user you use or there is an authentication cookie has left in the browser. There should not be a problem to see this node if you are an administrator. You can take a look at you are not authorized to view a page.

    Greetings,
    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
4 posts, 0 answered