Copied to clipboard

Flag this post as spam?

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


  • Dani 18 posts 38 karma points
    Jul 27, 2012 @ 02:03
    Dani
    0

    Error publising a site.

    Hello I have an umbraco site created in the my laptop, when I try to publish in the server I copied all the files,
    and converted the SQL CE database to SQL server.

    I'm too edit my web.config, here is...

    <connectionStrings>
    <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="server=173.248.177.6,1533;database=Ados_Umbraco;user id=admin_ados_umbraco;password=Ados###Umbraco@13579" providerName="System.Data.SqlClient"/>
    </connectionStrings>

    and the error is this:

    MANY THANKS...

    Server Error in '/' Application.
    --------------------------------------------------------------------------------

    Error running Reader:
    SQL Statement:
    select id, domainName from umbracoDomains

    Exception:
    System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode)
    at System.Data.SqlServerCe.UnmanagedLibraryHelper..ctor(String fileName)
    at System.Data.SqlServerCe.NativeMethodsHelper..ctor(String modulePath)
    at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath)
    at System.Data.SqlServerCe.NativeMethods.LoadNativeBinariesFromPrivateFolder(String privateInstall)
    at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()
    at System.Data.SqlServerCe.SqlCeConnection..ctor()
    at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)
    at SQLCE4Umbraco.SqlCeContextGuardian.ensureOpenBackgroundConnection(String connectionString)
    at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
    at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
    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: SqlCE4Umbraco.SqlCeProviderException: Error running Reader:
    SQL Statement:
    select id, domainName from umbracoDomains

    Exception:
    System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode)
    at System.Data.SqlServerCe.UnmanagedLibraryHelper..ctor(String fileName)
    at System.Data.SqlServerCe.NativeMethodsHelper..ctor(String modulePath)
    at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath)
    at System.Data.SqlServerCe.NativeMethods.LoadNativeBinariesFromPrivateFolder(String privateInstall)
    at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()
    at System.Data.SqlServerCe.SqlCeConnection..ctor()
    at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)
    at SQLCE4Umbraco.SqlCeContextGuardian.ensureOpenBackgroundConnection(String connectionString)
    at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
    at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

    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:


    [SqlCeProviderException: Error running Reader:
    SQL Statement:
    select id, domainName from umbracoDomains

    Exception:
    System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo)
    at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode)
    at System.Data.SqlServerCe.UnmanagedLibraryHelper..ctor(String fileName)
    at System.Data.SqlServerCe.NativeMethodsHelper..ctor(String modulePath)
    at System.Data.SqlServerCe.NativeMethods.LoadValidLibrary(String modulePath)
    at System.Data.SqlServerCe.NativeMethods.LoadNativeBinariesFromPrivateFolder(String privateInstall)
    at System.Data.SqlServerCe.NativeMethods.LoadNativeBinaries()
    at System.Data.SqlServerCe.SqlCeConnection..ctor()
    at System.Data.SqlServerCe.SqlCeConnection..ctor(String connectionString)
    at SQLCE4Umbraco.SqlCeContextGuardian.ensureOpenBackgroundConnection(String connectionString)
    at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
    at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
    SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +192
    SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] 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) +534
    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) +9010534
    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: 0uabl153jq452fhjxps5voj3 Request Type: GET
    Time of Request: 7/26/2012 5:55:02 PM Status Code: 500
    Request Encoding: Unicode (UTF-8) Response Encoding: Unicode (UTF-8)
    Trace Information
    Category Message From First(s) From Last(s)
    aspx.page Begin PreInit
    umbracoInit handling request 2.43047649910813E-05 0.000024
    request handler current url '' 0.0164221989107554 0.016398
    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.0351611727188791 0.018739
    Control Tree
    Control UniqueID Type Render Size Bytes (including children) ViewState Size Bytes (excluding children) ControlState Size Bytes (excluding children)
    __Page ASP.default_aspx 0 0 0
    Session State
    Session Key Type Value
    Application State
    Application Key Type Value
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    umbracoUrl System.String ados.biz.173-248-177-8.cld1.temphostspace.com:80/umbraco
    umbracoNeedConfiguration System.Boolean False
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/26/2012 11:55:02 PM
    Request Cookies Collection
    Name Value Size
    Response Cookies Collection
    Name Value Size
    Headers Collection
    Name Value
    Connection Keep-Alive
    Accept text/html, application/xhtml+xml, */*
    Accept-Encoding gzip, deflate
    Accept-Language es-ES
    Host ados.biz.173-248-177-8.cld1.temphostspace.com
    User-Agent Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
    Response Headers Collection
    Name Value
    X-AspNet-Version 4.0.30319
    Cache-Control private
    Content-Type text/html
    Form Collection
    Name Value
    Querystring Collection
    Name Value
    Server Variables
    Name Value
    ALL_HTTP HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:text/html, application/xhtml+xml, */* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:es-ES HTTP_HOST:ados.biz.173-248-177-8.cld1.temphostspace.com HTTP_USER_AGENT:Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
    ALL_RAW Connection: Keep-Alive Accept: text/html, application/xhtml+xml, */* Accept-Encoding: gzip, deflate Accept-Language: es-ES Host: ados.biz.173-248-177-8.cld1.temphostspace.com User-Agent: Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)
    APPL_MD_PATH /LM/W3SVC/139/ROOT
    APPL_PHYSICAL_PATH C:\Inetpub\vhosts\enkarterri.biz\ados.biz\
    AUTH_TYPE
    AUTH_USER
    AUTH_PASSWORD
    LOGON_USER
    REMOTE_USER
    CERT_COOKIE
    CERT_FLAGS
    CERT_ISSUER
    CERT_KEYSIZE
    CERT_SECRETKEYSIZE
    CERT_SERIALNUMBER
    CERT_SERVER_ISSUER
    CERT_SERVER_SUBJECT
    CERT_SUBJECT
    CONTENT_LENGTH 0
    CONTENT_TYPE
    GATEWAY_INTERFACE CGI/1.1
    HTTPS off
    HTTPS_KEYSIZE
    HTTPS_SECRETKEYSIZE
    HTTPS_SERVER_ISSUER
    HTTPS_SERVER_SUBJECT
    INSTANCE_ID 139
    INSTANCE_META_PATH /LM/W3SVC/139
    LOCAL_ADDR 173.248.177.8
    PATH_INFO /default.aspx
    PATH_TRANSLATED C:\Inetpub\vhosts\enkarterri.biz\ados.biz\default.aspx
    QUERY_STRING
    REMOTE_ADDR 83.52.173.240
    REMOTE_HOST 83.52.173.240
    REMOTE_PORT 52957
    REQUEST_METHOD GET
    SCRIPT_NAME /default.aspx
    SERVER_NAME ados.biz.173-248-177-8.cld1.temphostspace.com
    SERVER_PORT 80
    SERVER_PORT_SECURE 0
    SERVER_PROTOCOL HTTP/1.1
    SERVER_SOFTWARE Microsoft-IIS/7.5
    URL /default.aspx
    HTTP_CONNECTION Keep-Alive
    HTTP_ACCEPT text/html, application/xhtml+xml, */*
    HTTP_ACCEPT_ENCODING gzip, deflate
    HTTP_ACCEPT_LANGUAGE es-ES
    HTTP_HOST ados.biz.173-248-177-8.cld1.temphostspace.com
    HTTP_USER_AGENT Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0)

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

  • Dani 18 posts 38 karma points
    Jul 27, 2012 @ 10:29
    Dani
    0

    Me again, In the App_Data directory I have some folders and files, Have I to delete? If I use an SQL SERVER 2012 It's necesary this folder?

     

    Thanks

     

    Dani

Please Sign in or register to post replies

Write your reply to:

Draft