Hi, I'm using WebMatrix to deploy a test web site. I'm using a SQL Server Compact database. Locally it works fine. When I deploy the webiste to Winhost using Web Deploy, the site is throwing this permissions error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) 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.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or Network Service on IIS 6 and IIS 7, and the configured application pool identity on IIS 7.5) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user. To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access. Has anyone figured out how to successfully use SQL Server Compact here?
Did you use Visual Studio and Web Deploy to publish your site to our web server. If you used Web Matrix and Web Deploy than this should not be a problem. But if you used Visual Studio than there is chance that your ASPNet IUSR's ACL may have gotten altered. Try looking at this kb. http://support.Winhost.com/KB/a890/acl-was-altered-after-using-vs-web-deploy.aspx You'll need to open a ticket to our support department to double check your ACL for your account.
