Urgent: Application not working when used with different database user.
Dear Sir,
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>
Hi,
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:
www.sitefinity.com/.../installing_sitefinity_4_on_iis_7.aspx
If you are using IIS6:
www.sitefinity.com/.../installing_sitefinity_4_on_iis_6.aspx
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,
Stefani Tacheva
the Telerik team