Forums

Home / Developer Network / Forums / Sitefinity Older Versions (3.x): Set-up & Installation > SOLVED: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.

• Mike Bentzen

  Posted on Sep 1, 2010 (permalink)

  Hi,
  
  I just thought I might put up our experiences with this error. We had taken an exact copy of our installation, and put it on our webhost. No upgrade, no other changes.
  
  We were scratching our heads for ages, as only two other people on these forums received this error, and the suggestions were about upgrading the database in a full trust environment. We didn't upgrade the database, we had already created one content item per module, and we still received this error message.
  
  It turned out to be a database user permissions error. When copying the database from an SQL 2005 instance to Sql server 2000 instance, we didn't take a note of which user was logged in. The tables and stored procedures were not able to be accessed by the specified SQL connection string and this was the resulting error when we visited the website. If you get this error, check the permissions and make sure that the user can access the appropriate tables/stored procs.
  
  Kind Regards,
  
  Mike
  
  

  Reply

• Nabanita

  Posted on Jun 2, 2011 (permalink)

  Hello,
  
  I have got the same problem. I want to host my site with sitefinity in a shared server with medium trust level. I check the connection string in a very simple way with a default page. The connection string is working. My Databse is in 2008 sql server.
  
  Error:
  

  Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.

  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: Telerik.DataAccess.ProviderDatabaseUpgradeException: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.
  
  Version Information: Microsoft .NET Framework Version:2.0.50727.4211; ASP.NET Version:2.0.50727.4209
  
  Please help.
  Nabanita

  Reply

• Ivan Dimitrov Ivan Dimitrov

  Posted on Jun 2, 2011 (permalink)

  Hello Nabanita,
  
  The Upgrade method is called when  you are trying to upgrade the database or the schema version. You are trying to upgrade the database( for instance you have two websites or single website which uses different version from this one that was initially connected to the website) and since you are not running in Full Trust level and PermissionState.Unrestricted is false an error of type ProviderDatabaseUpgradeException is thrown. Please run the website locally in Full Trust so that the database will be upgraded properly. Then reupload the website and the local database to your host.
  
  
  Regards,
  Ivan Dimitrov
  the Telerik team

  Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply

• Nabanita

  Posted on Jun 2, 2011 (permalink)

  Hello,
  
  I have done what you suggested.
  Now I have done with sql server 2008 but the site was created with sql server 2005.
   But in local it is showing me an error:
  

  Can't load driver Telerik.DataAccess.Providers.ExtendedSqlServer2008Provider, Telerik.DataAccess from assembly .  Check driver and driverAttribute values from application config file.

  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: Nolics.ORMapper.Base.NolnetException: Can't load driver Telerik.DataAccess.Providers.ExtendedSqlServer2008Provider, Telerik.DataAccess from assembly .  Check driver and driverAttribute values from application config file.
  
  Please help on this.
  Eagerly waiting for your feedback.
  Nabanita
  

  Reply

• Ivan Dimitrov Ivan Dimitrov

  Posted on Jun 7, 2011 (permalink)

  Hi,
  
  The driver is the same for SQL 2005 and 2008
  
  <add name="DefaultConnection" driver="Telerik.DataAccess.Providers.ExtendedSqlServer2005Provider, Telerik.DataAccess"
                    connectionStringName="Sitefinity" />
  
  
  Regards,
  Ivan Dimitrov
  the Telerik team

  Do you want to have your say in the Sitefinity development roadmap? Do you want to know when a feature you requested is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items

  Reply

Home / Developer Network / Forums / Sitefinity Older Versions (3.x): Set-up & Installation > SOLVED: Exception of type 'Telerik.DataAccess.ProviderDatabaseUpgradeException' was thrown.