+1-888-365-2779
Try Now
More in this section

Forums / Set-up & Installation / sql2000 db setup problem on shared hosting environment

sql2000 db setup problem on shared hosting environment

13 posts, 0 answered
  1. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    04 Sep 2007
    Link to this post

    Configuration Error

    Hello

    Created new sitefinity project and at "Set database" page I chose SqlServer 2000 add fill the required information. My database is located on shared hosting enviroment, so I dont have full control over the database. I can't set up myself to be "db_ovner" as refered in manual.

    I get following error after clicking continue:

    Server Error in '/my_site' Application.



    Description:
    An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: EXECUTE permission denied on object 'sf_DataAccessVariables_ins', database 'my_database', owner 'dbo'.

    Source Error:

    Line 38:     <clear />
    Line 39: <add connectionStringName="DefaultConnection" applicationName="/"
    Line 40: name="Sitefinity" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />
    Line 41: </providers>
    Line 42: </roleManager>

    Source File: C:\_projects\web\my_site.com\web.config    Line: 40


    Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

    Is this a problem with me not beeing the db_owner? Is there a workaround this problem? My hosting provider won't let me set up permissions for database

    Thanks

    miran
  2. Bob
    Bob avatar
    330 posts
    Registered:
    24 Sep 2012
    04 Sep 2007
    Link to this post
    Hello Miran,

    In order to create or upgrade a database Sitefinity requires trust level Full for code permissions and execute permissions for the database. Most hosting providers allow shared hosting in medium trust. In this case you have to crate the database locally and upload it to your hosted server. I know some hosting providers do not allow uploading and attaching databases either. So when choosing hosting company you should look if they support SQL Express or allow you to upload databases.

    As your last option you could create a database locally, export the whole database using the property:
    Script Database to -> CREATE to -> File, and then run the scripts on the hosting server. Note this will require substantial amount of work.

    Greetings,
    Bob
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    04 Sep 2007
    Link to this post
    Hello,

    I created Database localy on my SqlExpress server and created sitefinity project with sqlserver 2000 setting.

    Localy everything works fine

    than I used Microsoft's sql server database publishing wizard, which copyes (or creates sql script) local database to a publishing server. I also used sql server 2000 compabiliti setting here, since my provider uses this database. Db was created sucesfully.

    I modified web.config's connection to point to hosted DB and uploaded site to my host. I get this error when accessing the site:

    Server Error in '/' Application.

    No code permissions to upgrade database. Run the application locally and upload the database to the live site.





    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.Cms.CmsCodeSecurityException: No code permissions to upgrade database. Run the application locally and upload the database to the live site.

    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:

    [CmsCodeSecurityException: No code permissions to upgrade database. Run the application locally and upload the database to the live site.]
    Telerik.Cms.Data.DefaultProvider.Initialize(String name, NameValueCollection config) +1521
    Telerik.ManagerBase`1.InstantiateProvider(ProviderSettings providerSettings, Type providerType) +670
    Telerik.ManagerBase`1.InstantiateProviders(ProviderSettingsCollection configProviders, IDictionary`2 providers, Type providerType) +132
    Telerik.ManagerBase`1.Initialize() +579
    Telerik.ManagerBase`1..ctor(String providerName) +18
    Telerik.ManagerBase`1..ctor() +11
    Telerik.Cms.CmsManager..ctor() +5
    Telerik.Cms.Web.UrlHelper..cctor() +672

    [TypeInitializationException: The type initializer for 'Telerik.Cms.Web.UrlHelper' threw an exception.]
    Telerik.Cms.Web.CmsHttpModule.BeginRequest(Object sender, EventArgs e) +1168
    System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
    System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64


    Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42


    Oh, one more thing. Everything works great if I run site locally with connection to remote database, so I think that database copyed with Db publishing wizard is ok.

    Miran
  4. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    05 Sep 2007
    Link to this post
    to correct myself:

    "Oh, one more thing. Everything works great if I run site locally with connection to remote database, so I think that database copyed with Db publishing wizard is ok."

    This is not true, only local site with local Db works fine... but remote Db looks ok to me, all the tables and procedures are there....

    Miran

  5. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    05 Sep 2007
    Link to this post
    Hi Miran,

    Make sure that Sitefinity assemblies in your local site have the same version number as those in your live site. Then try to connect the local site to the remote database, so the shared hosting database is upgraded with the right Sitefinity version.

    Please let us know how it goes.

    Regards,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  6. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    05 Sep 2007
    Link to this post
    Hi,

    assemblies in local and live site must be the same becouse I coppyed them directly from local to live site.

    i tried as you sugested, conected local site to remote Db and got the next error:

    Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.



    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.IO.FileNotFoundException: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

    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.

    Assembly Load Trace: The following information can be helpful to determine why the assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' could not be loaded.

    WRN: Assembly binding logging is turned OFF.
    To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
    Note: There is some performance penalty associated with assembly bind failure logging.
    To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

    Stack Trace:

    [FileNotFoundException: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.]
    System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
    System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
    System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
    System.Reflection.Assembly.Load(String assemblyString) +25
    System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

    [ConfigurationErrorsException: Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.]
    System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
    System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70
    System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
    System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
    System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed) +350
    System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +125
    System.Web.Compilation.BuildManager.CompileCodeDirectories() +525
    System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +448

    [HttpException (0x80004005): Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.]
    System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
    System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
    System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521

    [HttpException (0x80004005): Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.]
    System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923
    System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
    System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275


    Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

    How to check the assembly numbers, and can I update remote Db manualy to match to the right version?

    As I said, when running site localy, with local Db there is no problem(I,m using sqlExpress 2005 server and set up sql2000 Db there with no problems).

    any suggestions?

    thanks
    Miran
  7. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    05 Sep 2007
    Link to this post

    Hi Miran,

    Seems your database is upgraded now, because you are not getting the previous error.

    This error:
    Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

    shows that System.Web.Extensions is not installed on the host server.

    SInce Sitefinity does not have a reference to the above assembly, maybe your custom control is using it.
    You should talk to your hosting provider about this problem.

    Regards,

    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  8. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    07 Sep 2007
    Link to this post
    Hello again,

    This error:
    Could not load file or assembly 'System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.


    above error occured  on my local machine.... I solved this problem, It wasn't problem with sitefinity but something with Microsoft....sorry for that :)


    But this error:
    System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'sf_CmsVariables_pkq', database 'tomazd_merryland', owner 'dbo'.

    I get this error in both of theese scenarios:
    1) Running remote site (with remote DB)
    2) Running local site connected to remote DB

    in this scenario everyithing is OK:
    3) Running local site with local DB

    Once again: I'm on shared hosting enviroment, and I don't have perrmissions to be "db_ovner". Is there a way to get this running with that restriction?

    thank you

    Miran
  9. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    07 Sep 2007
    Link to this post
    to correct myself from previous post:

    1) Running remote site (with remote DB)
    i get these error:
    Telerik.Cms.CmsCodeSecurityException: No code permissions to upgrade database. Run the application locally and upload the database to the live site.

    2) Running local site connected to remote DB
    This:
    System.Data.SqlClient.SqlException: EXECUTE permission denied on object 'sf_CmsVariables_pkq', database 'tomazd_merryland', owner 'dbo'.


    in this scenario everyithing is OK:
    3) Running local site with local DB

    Thanks

    miran
  10. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    07 Sep 2007
    Link to this post
    Hi Miran,

    Thank you for elaborating on the problem.
    Seems you are in some kind of a deadlock:
        - Running local site with remote database - you have code permissions to upgrade database, but you have no permissions for the database.
        - Running remote site with remote database - you have permissions for the database, but you have no code permissions to upgrade database.

    Unfortunately, we don't know how can we help you in this situation.

    You should somehow export all database objects and data from the local DB to the remote DB.

    Greetings,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  11. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    10 Sep 2007
    Link to this post
    Hello

    Thanks for the support.

    "You should somehow export all database objects and data from the local DB to the remote DB."

    Did that, but the problem still remains....  Local site works great, copyed it to remote, exported Db with all the objects and data... but no luck....

    If you stumble across the sollution for this problem, please let me know.

    Thank you

    MIran
  12. Miran Zgec
    Miran Zgec avatar
    19 posts
    Registered:
    06 Oct 2006
    10 Sep 2007
    Link to this post
    Ok problem solved... exported Db to remote server again, and it started working...

    thanks for the support once again

    bye

    Miran
  13. Vlad
    Vlad avatar
    498 posts
    Registered:
    15 Jul 2016
    11 Sep 2007
    Link to this post
    Hi Miran,

    We are glad that everything is fine now.
    Please let us know if you experience other problems.

    Regards,
    Vlad
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
Register for webinar
13 posts, 0 answered