Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Martin 278 posts 662 karma points
    Mar 09, 2012 @ 09:50
    Martin
    0

    Permission Denied - E-Hosting Issue

    Hi all, 

    Im having some major issues with e-Hosting again.

    I had support look at a FTP error I was getting.

    They fixed that and now the site is down and im getting  the following error.

    Im not a developer, so its a little hard to understand what its falling at.

    Ive tried to log in, but the password is invalid.

    Any help in understanding what to do, would be grateful

    Thanks

    Martin

  • Martin 278 posts 662 karma points
    Mar 09, 2012 @ 09:51
    Martin
    0

    Server Error in '/' Application.


    The SELECT permission was denied on the object 'umbracoDomains', database 'FailteDB_Umbraco', schema 'martinm_failte'.

    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.Data.SqlClient.SqlException: The SELECT permission was denied on the object 'umbracoDomains', database 'FailteDB_Umbraco', schema 'martinm_failte'.

    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 (0x80131904): The SELECT permission was denied on the object 'umbracoDomains', database 'FailteDB_Umbraco', schema 'martinm_failte'.]
       System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +2073550
       System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064508
       System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
       System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
       System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
       System.Data.SqlClient.SqlDataReader.get_MetaData() +86
       System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +311
       System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
       System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
       System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +70
       Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +152
       umbraco.DataLayer.SqlHelpers.SqlServer.SqlServerHelper.ExecuteReader(String commandText, SqlParameter[] parameters) +37
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +87
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +142
       umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +89
       umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +132
       umbraco.cms.businesslogic.web.Domain.GetDomains() +158
       umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName) +44
       umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain) +232
       umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url) +523
       umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) +1062
       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14
       System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35
       System.EventHandler.Invoke(Object sender, EventArgs e) +0
       System.Web.UI.Page.OnPreInit(EventArgs e) +9009702
       System.Web.UI.Page.PerformPreInit() +31
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +328
    



    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

    Request Details

    Session Id: 5vpke5d4zc4e0nyductfbjsa Request Type: GET
    Time of Request: 09/03/2012 08:41:52 Status Code: 500
    Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)

    Trace Information

    CategoryMessageFrom First(s)From Last(s)
    aspx.page Begin PreInit    
    umbracoInit handling request 2.07341103761168E-05 0.000021
    request handler current url '' 0.0261675991896803 0.026147
    Unhandled Execution Error
    Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
      at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
      at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0()
      at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
      at umbraco.cms.businesslogic.web.Domain.GetDomains()
      at umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName)
      at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain)
      at umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url)
      at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
      at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
      at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
      at System.EventHandler.Invoke(Object sender, EventArgs e)
      at System.Web.UI.Page.OnPreInit(EventArgs e)
      at System.Web.UI.Page.PerformPreInit()
      at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    0.0275859659254094 0.001418
  • Martin 278 posts 662 karma points
    Mar 09, 2012 @ 14:43
    Martin
    0

    E-Hosting managed to restore the site for me. Its was a permission setting on the database.

     

Please Sign in or register to post replies

Write your reply to:

Draft