Urgent: Application not working when used with different database user.
We have used sa database user during our development . On production we are using different database user ( not sa). This user is db_owner and default schema is dbo. We are receiving the following error.
<providers> Line 78: <add name="SitefinitySiteMap" type="Telerik.Sitefinity.Web.SitefinitySiteMap, Telerik.Sitefinity" taxonomyProvider="OpenAccessDataProvider" pageTaxonomy="Pages" rootNode="FrontendSiteMap" pageProvider="OpenAccessDataProvider" /> Line 79: </providers>
There is most probably something in your configuration file that is causing the troubles. Firstly I want to share the following article which can guide you when deploying your project on IIS:
If you are using IIS6:
Also verify that you have exited Cassini or any other server ( like the built-in server in VS ) before starting your IIS website. Another option for you is to check your webconfig file and compare it to the webconfig of a brand new project, because there might be some errors in code of the file.
All the best,
the Telerik team