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.

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

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

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?

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.

Greetings,
Nikolay Datchev
the Telerik team

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

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.

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

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

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.

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

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

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.

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.

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.

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.

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

Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

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...

Webinars

Tools

Progress, Telerik, Sitefinity and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries.