User does not have permission to perform this action.
i'm trying to move my project to my local iis, using sql express, i'm add the pool application and a site but i get this error:
Server Error in '/' Application.User does not have permission to perform this action.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: User does not have permission to perform this action.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: User does not have permission to perform this action.] Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps, ConnectionPoolType poolType, LogEventStore pes) +1551 OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) +387[DataStoreException: User does not have permission to perform this action. Telerik.OpenAccess.RT.sql.SQLException: User does not have permission to perform this action. at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps, ConnectionPoolType poolType, LogEventStore pes) at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType)] DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_b01d052ed26542698618ef3c6452354b.Initialize(String providerName, NameValueCollection config, Type managerType) +405 Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1976 Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +74 Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +526[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) +117 System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +247 System.Activator.CreateInstance() +88 Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +120 Telerik.Sitefinity.Services.SystemManager.Initialize() +232 Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +307 Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +386 Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +116 System.Web.HttpApplication.RegisterEventSubscriptionsWithIIS(IntPtr appContext, HttpContext context, MethodInfo[] handlers) +575 System.Web.HttpApplication.InitSpecial(HttpApplicationState state, MethodInfo[] handlers, IntPtr appContext, HttpContext context) +352 System.Web.HttpApplicationFactory.GetSpecialApplicationInstance(IntPtr appContext, HttpContext context) +407 System.Web.Hosting.PipelineRuntime.InitializeApplication(IntPtr appContext) +375[HttpException (0x80004005): Exception has been thrown by the target of an invocation.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +11700976 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +141 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) +4869205Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272<connectionStrings> <remove name="LocalSqlServer" /> <add connectionString="Data Source=.\SQLEXPRESS;Integrated Security=False;User ID=***;Password=***;initial catalog=sitefinity; providerName=System.Data.SqlClient;" name="Sitefinity" /></connectionStrings>My mistake,
I was editing this file:
~\web.config
but the connection is in this file:
~\App_Data\Sitefinity\Configuration\DataConfig.config
and the connection:
<connectionStrings> <add connectionString="Server=.\SQLEXPRESS;Database=sitefinity;User ID=***;Password=***" name="Sitefinity" /></connectionStrings>Hello,
Thank you for using our service!
The error you get is general SQL error, often thrown if your SQL server account lacks some permissions which are required by specific operations. Depending on how you have set up your IIS application pool, you need to allow permissions to create and modify tables. By default, you should allow these permissions to Network Service account. Make sure that your web user (NEWORK SERVICE) has full permissions (Create/Edit) over the database.
Here is a link to the article that explains how to do that (search for SQL SERVER section):
http://msdn.microsoft.com/en-us/library/ff647402.aspx
Please do not hesitate to let me know if any further questions occur, or you need any additional information. I'll be glad to help you.
Greetings,
Stefani Tacheva
the Telerik team