Error after install
I just installed SF 4 CTP and used the project manager to create a project and immediately get an error when I try to browse or use the admin for the new site. Here's the error dump:
This is running on Win Server 2008 R2 x64.
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.
|
[UnauthorizedAccessException: Access to the path 'C:\inetpub\wwwroot\Telerik\App_Data\Sitefinity\Configuration\SecurityConfig.config' is denied.] System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) +10546931 System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) +2580 System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) +138 System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) +89 System.Xml.XmlWriter.Create(String outputFileName, XmlWriterSettings settings) +5096166 Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.GetConfigurationWriter(ConfigSection section) +164 Telerik.Sitefinity.Configuration.Data.XmlConfigProvider.SaveSection(ConfigSection section) +198 Telerik.Sitefinity.Configuration.ConfigManager.SaveSection(ConfigSection section) +29 Telerik.Sitefinity.Security.SecurityManager..cctor() +315 [TypeInitializationException: The type initializer for 'Telerik.Sitefinity.Security.SecurityManager' threw an exception.] Telerik.Sitefinity.Security.SecurityManager.GetCurrentUser() +0 Telerik.Sitefinity.Configuration.UserPolicyHandler.GetPolicyNames(ConfigProvider configProvider, ConfigSection section) +23 Telerik.Sitefinity.Configuration.ConfigElement.GetValueFromPolicy(ConfigPolicyHandler handler, ConfigurationProperty prop, Object& value) +149 Telerik.Sitefinity.Configuration.ConfigElement.get_Item(ConfigurationProperty prop, ConfigPolicyHandler policyHandler, String policyName) +122 Telerik.Sitefinity.Configuration.ConfigElement.get_Item(String propertyName) +102 Telerik.Sitefinity.Localization.Configuration.ResourcesConfig.get_Cultures() +23 [TargetInvocationException: Exception has been thrown by the target of an invocation.] System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner) +0 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) +808 System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +38 System.Reflection.RuntimePropertyInfo.GetValue(Object obj, Object[] index) +36 Telerik.Sitefinity.Configuration.ConfigElement.ApplyInstanceAttributes(Object instance) +218 Telerik.Sitefinity.Configuration.ConfigElement.get_Properties() +48 Telerik.Sitefinity.Configuration.ConfigElement.get_Item(String propertyName) +22 Telerik.Sitefinity.Localization.Configuration.ResourcesConfig.get_Providers() +23 Telerik.Sitefinity.Data.ManagerBase`1.Initialize() +547 Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +36 Telerik.Sitefinity.Data.ManagerBase`1..ctor() +25 Telerik.Sitefinity.Localization.Res..cctor() +31 [TypeInitializationException: The type initializer for 'Telerik.Sitefinity.Localization.Res' threw an exception.] Telerik.Sitefinity.Localization.Res.RegisterResource() +0 Telerik.Sitefinity.Abstractions.ObjectFactory.RegisterIoCTypes() +1270 Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +67 Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +32 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +480 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +336 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +350 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +382 [HttpException (0x80004005): The type initializer for 'Telerik.Sitefinity.Localization.Res' threw an exception.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11301302 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4338644 |
Ok, I added permissions to the root directory for SF site for IIS_USR and Network users and fixed the problem above. Then I could proceed to Admin setup. When it prompts for DB credentials in Setup page, I then get error about user not having CREATE privilege for either SQLExpress or my SQL Server instance. For SQL Server, I entered the 'sa' user credentials which obviously should not have an issue and I get the following error:
I wonder if SF even has a QA process b/c I've had these same type of errors on every version of SF i ever install... I know once it's running it's a feature-rich (bloated?) CMS but these setup errors are a sign of terrible QA since I get them on completely clean server VM's... Not Good. Please advise and hopefully a post like this will help shed light that some work remains to get SF to a polished state and I'm talking about the current version too, not just CTP.
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.
|
[SQLException: CREATE DATABASE permission denied in database 'master'.] Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeUpdate(String sql) +323 Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.execute(String sql) +9 OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +436 [OpenAccessException: SQL exception on 'CREATE DATABASE telerik' : CREATE DATABASE permission denied in database 'master'.] Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +13 OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +105 OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.ExecuteSqlScript(String script, Connection con, SqlDriver sqlDriver, Boolean noShredder) +649 OpenAccessRuntime.DataObjects.tools.ant.DatabaseCreationTask.createDatabase() +1461 [OpenAccessException: Telerik.OpenAccess.OpenAccessException: SQL exception on 'CREATE DATABASE telerik' : CREATE DATABASE permission denied in database 'master'.] Telerik.OpenAccess.RT.ExceptionWrapper.Throw() +13 OpenAccessRuntime.DataObjects.tools.ant.DataObjectsTaskBase.throwBuildException(String str, Exception e) +105 OpenAccessRuntime.DataObjects.tools.ant.DatabaseCreationTask.createDatabase() +1719 Telerik.OpenAccess.RT.OpenAccessSchemaAdapter.CreateDatabase(Boolean checkOnly) +555 Telerik.OpenAccess.SchemaHandlerImpl.Telerik.OpenAccess.ISchemaHandler.CreateDatabase() +60 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.UpgradeDatabase(Database db) +63 Telerik.Sitefinity.Data.Metadata.OAMetadataLoader.Init(String connectionName, String connectionConfig, Assembly[] references, CultureInfo[] cultures) +922 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.SetDynamicFields(String connName, XElement config, Assembly[] references, CultureInfo[] cultures, XNamespace xmlns) +832 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.ParseConnectionString(String connectionStringName, String key, Assembly[] references, CultureInfo[] cultures) +3259 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.EstablishConnection(String connName, String key, Assembly[] references, CultureInfo[] cultures) +23 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.GetDatabase(String connectionStringName, Assembly[]& references, CultureInfo[] cultures, Boolean& requiresReset) +146 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.InitializeProvider(IOpenAccessDataProvider provider, String connectionName) +121 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.InitializeDatabase(DataProviderBase dataProvider, NameValueCollection config) +110 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.Initialize(String providerName, NameValueCollection config, Type managerType) +22 Telerik.Sitefinity.Data.DataProviderBase.Initialize(String providerName, NameValueCollection config, Type managerType, Boolean initializeDecorator) +975 Telerik.Sitefinity.Data.DataProviderBase.Initialize(String providerName, NameValueCollection config, Type managerType) +18 Telerik.Sitefinity.Web.UI.Backend.StartupWizard.CreateInstantProvider(String providerName, String connectionString, ConfigElementDictionary`2 providers) +795 Telerik.Sitefinity.Web.UI.Backend.StartupWizard.GetRoleProvider() +116 Telerik.Sitefinity.Web.UI.Backend.AdministratorPane.ValidateMembership() +29 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981 |
Hi Chris Douglass,
Please take a look at the posts below
Wish those helped but they don't. The sql server instance is on another machine. I can connect from other client VMs to this SQL instance and create databases without a problem. So, I'm not sure (again) why the SF install is so fragile about its sql settings.
I can create DBs from other remote machines using either login as well... sa or windows integrated.
I tried to upload a screen shot here but don't see an option for that. Any other ideas?
If you're connecting to a remote SQL Server 2008 R2 instance like I am, do you specify only the server name at the top or both server\instance? I tried both and when I use instance name it gives me a different error. And, since I'm getting I a permissions error I think I can safely assume that I was able to connect to the remote SQL server. So, I don't think this is a connection issue.
Any other ideas?
In case it helps anyone, the fix is to run the SiteFinity Project Manager app as Administrator... Has nothing to do with your SQL logins per se... What a pain.