Sitefinity throws exception with IIS
Dear Sitefinity Team,
I have started evaluating SiteFinity CMS. Sitefinity seems to be working fine with its own Admin Console (Cassini). However if I create a virtual directory for the folder so that my team member could view the changes it throws an error like 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. |
|
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. |
|
Hello Deepak Vasudevan,
Make sure that you have set your project on IIS as described in this article: Configuring the IIS to host Sitefinity projects (section Configuring folder permissions).
The most common reason for getting this exception is if your application pool identity does not have sufficient permissions over the App_Data folder and its content. If your website is added to source safe make sure it is checked out and is not read only.
Best wishes,
Victor Velev
the Telerik team
Now I have given full WRITE_ACCESS to App_Data and its descendants. Now it throws an error message as below. From where does it pick up the connection string.
CREATE DATABASE permission denied in database 'master'.
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:
Telerik.OpenAccess.RT.sql.SQLException: CREATE DATABASE permission denied in
database 'master'.
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:
[SQLException: CREATE DATABASE permission denied in database 'master'.]
Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +191
Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +5
OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +310
[OpenAccessException: SQL exception on 'CREATE DATABASE gangescms_sitefinity' : CREATE DATABASE permission denied in database 'master'.]
Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +7
OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +29
OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +365
OpenAccessRuntime.DataObjects.tools.ant.DatabaseCreationTask.createDatabase() +1062
[OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATE DATABASE gangescms_sitefinity' : CREATE DATABASE permission denied in database 'master'.]
DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_f3a198b419c946f19a65052f1fec506d.Initialize(String providerName, NameValueCollection config, Type managerType) +197
Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1478
Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +63
Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +161
Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +131
Telerik.Sitefinity.Data.Metadata.MetadataManager..ctor() +12
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +98
System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +241
System.Activator.CreateInstance() +103
Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +80
Telerik.Sitefinity.Services.SystemManager.Initialize() +95
Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +233
Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +192
Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +24
System.Web.Routing.UrlRoutingModule.System.Web.IHttpModule.Init(HttpApplication application) +10
System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +431
System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +194
System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +339
System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +253
[HttpException (0x80004005): Exception has been thrown by the target of an invocation.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +8950644
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +97
System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +256
Hi Deepak,
This is a general issue with the database permissions. I suggest that you should use SQL server. You should create the database manually and then set the name and user in Sitefinity.
Kind regards,
Ivan Dimitrov
the Telerik team
Dear Sitefinity Support,
I am using SQL Server only. I am able to launch Start -> All Programs -> Telerik -> Sitefinity 4.1 -> Project Manager. This is using the same files and database. It works. When I wanted to create a virtual directory for it in IIS I am not able to.
Can you guide me please?
Hi Deepak,
Please make sure that the user that runs your application pool is added as a user to your SQL server. It looks like this use has sufficient permissions.
Best wishes,
Ivan Dimitrov
the Telerik team
Hi,
I am uploading the latest version from my test server to the production server and I am getting the same error. I am not sure why Sitefinity is trying to install anything here. I am moving the 1339 version from the test server to the production. All the files and DB's have been moved and I get the following message. Please let me know how to fix this. The site was working fine on the 1098 version.
-------------------
Server Error in '/' Application.
CREATE DATABASE permission denied in database 'master'.
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: Telerik.OpenAccess.RT.sql.SQLException: CREATE DATABASE permission denied in database 'master'.
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:
[SQLException: CREATE DATABASE permission denied in database 'master'.]
Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +191
Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +5
OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +301
[OpenAccessException: SQL exception on 'CREATE DATABASE BWCORPORATE' : CREATE DATABASE permission denied in database 'master'.]
Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +7
OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +29
OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +356
OpenAccessRuntime.DataObjects.tools.ant.DatabaseCreationTask.createDatabase() +1062
[OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATE DATABASE BWCORPORATE' : CREATE DATABASE permission denied in database 'master'.]
DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_e1cef8ebba66467db45460958792a3e1.Initialize(String providerName, NameValueCollection config, Type managerType) +197
Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1478
Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +63
Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +161
Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +131
BuildUp_Telerik.Sitefinity.Data.Metadata.MetadataManager(IBuilderContext ) +179
Telerik.Microsoft.Practices.ObjectBuilder2.DynamicMethodBuildPlan.BuildUp(IBuilderContext context) +12
Telerik.Microsoft.Practices.ObjectBuilder2.BuildPlanStrategy.PreBuildUp(IBuilderContext context) +195
Telerik.Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context) +190
Telerik.Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +163
[ResolutionFailedException: Resolution of the dependency failed, type = "Telerik.Sitefinity.Data.Metadata.MetadataManager", name = "OpenAccessDataProvider".
Exception occurred while: Calling constructor Telerik.Sitefinity.Data.Metadata.MetadataManager(System.String providerName).
Exception is: OpenAccessException - Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATE DATABASE BWCORPORATE' : CREATE DATABASE permission denied in database 'master'.
-----------------------------------------------
At the time of the exception, the container was:
Resolving Telerik.Sitefinity.Data.Metadata.MetadataManager,OpenAccessDataProvider
Calling constructor Telerik.Sitefinity.Data.Metadata.MetadataManager(System.String providerName)
]
DynamicModule.ns.Wrapped_OpenAccessTaxonomyProvider_ccb707ec539a4e0496bcf101df23934c.Initialize(String providerName, NameValueCollection config, Type managerType) +195
Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1478
Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +63
Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +161
Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +131
Telerik.Sitefinity.Taxonomies.TaxonomyManager..ctor() +12
[TargetInvocationException: Exception has been thrown by the target of an invocation.]
System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +98
System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +241
System.Activator.CreateInstance() +103
Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +80
Telerik.Sitefinity.Modules.DefinitionsHelper.CreateTaxonomyLink(Guid id, String commandName, String commandArgument, WidgetBarSectionElement sidebar) +61
Telerik.Sitefinity.Modules.Libraries.Documents.DocumentsDefinitions.DefineBackendListView(ConfigElement parent, String controlDefinitionName, String viewName, Boolean viewDocumentsByLibrary) +10954
Telerik.Sitefinity.Modules.Libraries.Documents.<>c__DisplayClass14.<DefineBackendContentView>b__e() +37
System.Lazy`1.CreateValue() +361
System.Lazy`1.LazyInitValue() +104
System.Lazy`1.get_Value() +89
Telerik.Sitefinity.Configuration.ConfigElementLazyItem`1.get_Element() +82
Telerik.Sitefinity.Configuration.ConfigElementDictionary`2.TryGetValueInternal(TKey key, TElement& element) +41
Telerik.Sitefinity.Configuration.ConfigElementDictionary`2.GetElementByKey(String key) +73
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadCollectionElement(ConfigElementCollection collection, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading) +538
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading, Boolean validateTagName) +391
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadPropertyElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading) +332
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading, Boolean validateTagName) +523
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadCollectionElement(ConfigElementCollection collection, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading) +655
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading, Boolean validateTagName) +391
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadPropertyElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading) +332
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadElement(ConfigElement element, XmlReader reader, ConfigPolicyHandler policyHandler, String policyName, Boolean isUpgrading, Boolean validateTagName) +523
Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.LoadSection(ConfigSection section, ConfigPolicyHandler policyHandler, String policyName) +275
Telerik.Sitefinity.Configuration.ConfigSection.Initialize(ConfigProvider provider, ConfigPolicyHandler policyHandler, String policyName, Boolean singlePolicy) +149
Telerik.Sitefinity.Configuration.ConfigSection.Initialize(ConfigProvider provider) +16
Telerik.Sitefinity.Configuration.Config.Get() +128
Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute..cctor() +10
[TypeInitializationException: The type initializer for 'Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute' threw an exception.]
Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute..ctor() +0
BuildUp_Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute(IBuilderContext ) +89
Telerik.Microsoft.Practices.ObjectBuilder2.DynamicMethodBuildPlan.BuildUp(IBuilderContext context) +12
Telerik.Microsoft.Practices.ObjectBuilder2.BuildPlanStrategy.PreBuildUp(IBuilderContext context) +195
Telerik.Microsoft.Practices.ObjectBuilder2.StrategyChain.ExecuteBuildUp(IBuilderContext context) +190
Telerik.Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +163
[ResolutionFailedException: Resolution of the dependency failed, type = "Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute", name = "(none)".
Exception occurred while: Calling constructor Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute().
Exception is: TypeInitializationException - The type initializer for 'Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute' threw an exception.
-----------------------------------------------
At the time of the exception, the container was:
Resolving Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute,(none)
Calling constructor Telerik.Sitefinity.Modules.Libraries.Web.LibraryRoute()
]
Telerik.Microsoft.Practices.Unity.UnityContainer.DoBuildUp(Type t, Object existing, String name, IEnumerable`1 resolverOverrides) +327
Telerik.Microsoft.Practices.Unity.UnityContainer.Resolve(Type t, String name, ResolverOverride[] resolverOverrides) +15
Telerik.Microsoft.Practices.Unity.UnityContainerExtensions.Resolve(IUnityContainer container, ResolverOverride[] overrides) +81
Telerik.Sitefinity.Abstractions.ObjectFactory.Resolve() +72
Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +1499
Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +192
Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +24
System.Web.Routing.UrlRoutingModule.System.Web.IHttpModule.Init(HttpApplication application) +10
System.Web.HttpApplication.InitModulesCommon() +80
System.Web.HttpApplication.InitModules() +43
System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +828
System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +304
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +107
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +327
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1
Hello Madhavan,
I have replied to you in the support thread you have opened, you can check my response there. For your convenience I'm also pasting my reply below:
"Could it be that your DB was created with windows authentication so the owner was the my user account on your local machine? If that's the case, then after uploading the project to the server , the owner will be "null" because my there is no such login in server SQL.The error you are experiencing is pretty generic, and seems to be related to improper user permissions, can you please verify if everything is set up properly?"
Regards,
Boyan Barnev
the Telerik team
Hi Boyan,
In the Microsoft Windows Server 2008 with IIS 7.0 section of the Configuring the IIS to host Sitefinity projects article it lists Desktop Experience as a requirement. Can you please explain why this is required?
Thanks!
Devin
Hello Devin,
You need Desktop Experience set to be able to generate thumbnails for videos in Sitefinity.
Kind regards,
Boyan Barnev
the Telerik team
hello,
I was still working on sitefinity,I rebooted it so I got this error :
Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
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.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information.
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.
Please I need a solution for the bug