No Database
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
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
>
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
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