DataBase Missing Vanilla Install 4.1
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. |
|
I get the same thing. I am evaluating SiteFinity and I can create a basic project alright and view in their integrated browser. If I try to deploy to a local IIS my site no longer works and I get the exact error you describe. Any ideas or suggestions anyone?
I ultimately got it working by not using the attached MDF file via the connection string as it was configured. I made a copy of the MDF file (and log) in the App_Data folder and moved them elsewhere. I then attached them to my SQL server manually and configured a known user to have access. Once I did this I modified the connection string used by SiteFinity to point to this new database and all worked correctly.
Hope this helps others.
Same
Hi Jaime Weise,
It is possible to receive this exception due to connectivity problem to your database. Do you happen to receive the same error once you create a second project with an mdf attached file? My suggestion is to make sure that the SQL Instance is running properly and has its Named Pipes and TCP/IP Enabled. You can check these settings from the SQL Server Configuration Manager.
Excuse us for the late response, and please let me know whether you still have issues with the database connection.
Kind regards,
Hristo Borisov
the Telerik team
Just curious as to why this is happening? I see there's a workaround but yesterday everything worked fine. Today, not so much. I'm not having connectivity problems as other MDF files in other projects run just fine. Is this a bug?
Hello KMac,
First if you are using IIS to host Sitefinity the account under which the application pool is running needs to both have file system permissions to the database files plus be granted database permissions to connect to the parent database instance (the SQLExpress instance specified in the connection string) , that has a valid SQL Server login. SQLExpress seems to come with at least the BUILTIN\Users and NT AUTHORITY\SYSTEM logins. Once authenticated to the parent instance, the user will be granted sysadmin permissions to his own user instance. You may need to add an SQL Server login for NETWORK SERVICE if your pool runs under this account.
Another thing is that, if one user attaches the database files to his user instance it acquires an exclusive file system lock on them. That would mean that if you have run your site from within the development server, using the same (usually Administrator account) as Visual Studio is using, you might have not experienced that issue before. But when running on IIS, as Visual Studio attaches the files (as Administrator) your application pool is not able to access them any longer.
Also opening the MDF from the server explorer(Data connections) in Visual studio can lock the MDF and it cannot be accessed by another process.
Hello,
I wanted to simple get Sitefinity up and begin taking a look, I am continuely getting' GetCreateDatabaseSql : Database= missing' when I try to connect to my SQLExpress database. I have added the MIBPortal database to SQLExpress and I tried without adding it. I have Windows7, SQLExpress and IIS7.5. I have check and double checked the IIS setup and compared it to your online documentation. My security is set and yet I can not even get started. This has been very disappointing.
You can see by my attached images that I have added every SQL Login I know of. Specifically I added:
'IIS APPPOOL\MIBPORTAL' as a SQL Login and to the App_Data directory in the: 'C:\inetpub\wwwroot\MIBPortal\App_Data' directory.
Thank you.
Hello Jeff,
Try setting the Identity of your ApplicationPool to NETWORK SERVICE and again make sure that this user exists for the database you have.
Regards,
Ivan Dimitrov
the Telerik team
Thank you for you reply,
I was able to install the database on SQL Server 2008 which I installed on my development pc. The problem I am having now is that I can not move the site to my IIS 7.5 server. The steps I am following:
1) Setup New Site with project manager.
2) Setup new IIS 7.5 website (Integrated and ASP.Net 4.0.30319 App Pool)
3) I then setup new database on SQL 2008
4) Browse to Sitefinity Setup and setup new database, etc.
5) Proceed to setup new Page
6) Publish new page
7) Try to View new page and can not. It seems like IIS can not find the new page.
From this point I can't browse to any other pages. If I go out of the site, close the browser and then go back in I can then view the new page but if I create another new page then I can't view it and so on.
If I repeat all steps above except I browse from the Project Manager with its integrated webserver (e.g. I do not setup the IIS site). Then everything works as expected. I then completely removed IIS and I ran a full silent repair of the .NET Framework 4.0 and still got the same bad result. It is as if IIS is just not compatible on my laptop? What might be causing this? My laptop is only a few weeks old and it is complete patched absolutly no changes to any configurations. I tried turing off the firewall and that did not help. Not sure if a: aspnet_regiis.exe –i would help?? Really stumped!!
I did see the following in my application event viewer: (seems to imply some sort of security/access problem but why would such a problem happen only after I try to browse to a newly created page? Also, IIS_IUSRS had Modify access to the directory root.
Log Name: Application
Source: ASP.NET 4.0.30319.0
Date: 6/27/2011 10:13:27 PM
Event ID: 1309
Task Category: Web Event
Level: Warning
Keywords: Classic
User: N/A
Computer: NCSPortable4.CreditCentral.local
Description:
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 6/27/2011 10:13:27 PM
Event time (UTC): 6/28/2011 2:13:27 AM
Event ID: 84141d603c524084b2cf886b7a78e139
Event sequence: 387
Event occurrence: 2
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/2/ROOT-1-129536976829780939
Trust level: Full
Application Virtual Path: /
Application Path: C:\inetpub\wwwroot\MIBTest1\
Machine name: NCSPORTABLE4
Process information:
Process ID: 6540
Process name: w3wp.exe
Account name: IIS APPPOOL\MIBTest1
Exception information:
Exception type: HttpException
Exception message: You are not authorized to access this page
at Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context)
at System.Web.Routing.UrlRoutingModule.OnApplicationPostResolveRequestCache(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Request information:
Request URL: http://ncsportable4:81/helloall/Action/Edit
Request path: /helloall/Action/Edit
User host address: fe80::29c7:5ff0:3b90:6bdcC:\inetpub\wwwroot\MIBTest1\
User: Anonymous
Is authenticated: False
Authentication Type: Sitefinity
Thread account name: IIS APPPOOL\MIBTest1
Thread information:
Thread ID: 74
Thread account name: IIS APPPOOL\MIBTest1
Is impersonating: False
Stack trace: at Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context)
at System.Web.Routing.UrlRoutingModule.OnApplicationPostResolveRequestCache(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Custom event details:
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="ASP.NET 4.0.30319.0" />
<EventID Qualifiers="32768">1309</EventID>
<Level>3</Level>
<Task>3</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2011-06-28T02:13:27.000000000Z" />
<EventRecordID>33602</EventRecordID>
<Channel>Application</Channel>
<Computer>NCSPortable4.CreditCentral.local</Computer>
<Security />
</System>
<EventData>
<Data>3005</Data>
<Data>An unhandled exception has occurred.</Data>
<Data>6/27/2011 10:13:27 PM</Data>
<Data>6/28/2011 2:13:27 AM</Data>
<Data>84141d603c524084b2cf886b7a78e139</Data>
<Data>387</Data>
<Data>2</Data>
<Data>0</Data>
<Data>/LM/W3SVC/2/ROOT-1-129536976829780939</Data>
<Data>Full</Data>
<Data>/</Data>
<Data>C:\inetpub\wwwroot\MIBTest1\</Data>
<Data>NCSPORTABLE4</Data>
<Data>
</Data>
<Data>6540</Data>
<Data>w3wp.exe</Data>
<Data>IIS APPPOOL\MIBTest1</Data>
<Data>HttpException</Data>
<Data>You are not authorized to access this page
at Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context)
at System.Web.Routing.UrlRoutingModule.OnApplicationPostResolveRequestCache(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
</Data>
<Data>ncsportable4:81/.../Data>
<Data>/helloall/Action/Edit</Data>
<Data>fe80::29c7:5ff0:3b90:6bdc%12</Data>
<Data>Anonymous</Data>
<Data>False</Data>
<Data>Sitefinity</Data>
<Data>IIS APPPOOL\MIBTest1</Data>
<Data>74</Data>
<Data>IIS APPPOOL\MIBTest1</Data>
<Data>False</Data>
<Data> at Telerik.Sitefinity.Web.SitefinityRoute.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.RouteCollection.GetRouteData(HttpContextBase httpContext)
at System.Web.Routing.UrlRoutingModule.PostResolveRequestCache(HttpContextBase context)
at System.Web.Routing.UrlRoutingModule.OnApplicationPostResolveRequestCache(Object sender, EventArgs e)
at System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
</Data>
</EventData>
</Event>
Hi Jeff,
Please make sure that you have configured IIS properly. Since the project runs fine through the built-in server I suppose that the problem is related to the infrastructure and more especially to IIS settings
Kind regards,
Ivan Dimitrov
the Telerik team
Hello and thank you for your support.
As it turns out the issue I was having was caused by version 9 of AVG virus protection. The LinkScanner component has been causing this and similar problems for other developers (those running IIS locally) for a while now and is still not resolved. The only way around it is to disable all LinkScanner features. I sent AVG Support an email letting them know that this needs to be addressed.
I have not used my local copy of IIS until I started testing Sitefinity so I incorrectly linked the problems with Sitefinity. I am certain this was also causing the problems I was having with the SQLExpress database setup. Thank you for your patience and support.
I have the same problem. please help me !
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. |
|
I have the same problem. please help me !
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. |
|
My new problem is this:
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. |
|
Hello,
It looks like you are not using .NET 4.0 version that is required for Sitefinity. Your stack shows that you are loading System.ServiceModel, Version=3.0.0.0
All the best,
Ivan Dimitrov
the Telerik team
I followed all the steps here and was able to get it working with mdf under app_data. Turns out, that since I first ran the project under cassini, cassini was locking the mdf file. I ended up restarting my machine to unlock the file and all was good...