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

Forums / Set-up & Installation / Config error when configuring database settings

Config error when configuring database settings

6 posts, 0 answered
  1. Kalyan Mangu
    Kalyan Mangu avatar
    1 posts
    Registered:
    29 Oct 2007
    18 Jan 2008
    Link to this post
    Hi,

    I have installed sitefinity 3.1 standard edition in my system. I have created a new project. Using project manager, I cliked on the edit link of the project, where I specified the database connection settings which include server name,username, password and database name. When I submitted the details, I am getting the following error

    Invalid object name 'sys.procedures'.
    Invalid object name 'sys.schemas'.
    Invalid object name 'sys.sql_modules'.


     <add connectionStringName="DefaultConnection" applicationName="/"
    Line 46:           name="Sitefinity" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />

    Are there any settings I need to change ?

    Thanks
    Mangu


  2. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    18 Jan 2008
    Link to this post
    Hello Kalyan Mangu,

    What version of SQL Server are you using? Make sure that the Nolics drivers are properly set in the web.config, e.g.:

        - in case of SQL Server 2000:
    <telerik>  
        <dataAccess defaultConnection="DefaultConnection">   
          <connections>  
            <add name="DefaultConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2000Provider"  
              connectionStringName="Sitefinity" />  
            <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2000Provider, Telerik.Cms.Engine.Data"  
              connectionStringName="Sitefinity" />  
          </connections>  
     
        </dataAccess> 
       
        - in case of SQL Server 2005:
    <telerik>  
        <dataAccess defaultConnection="DefaultConnection">   
          <connections>  
            <add name="DefaultConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2005Provider"  
              connectionStringName="Sitefinity" />  
            <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data"  
              connectionStringName="Sitefinity" />  
          </connections>  
     
        </dataAccess>  

    Regards,
    Rebecca
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. Wendy
    Wendy avatar
    14 posts
    Registered:
    07 Jun 2004
    12 Feb 2008
    Link to this post
    I am having exactly the same issue and it appears that the nolics drivers are set correctly in the web.config.  I'm using SQL Server 2005. Anything else I should be checking?   Thanks.  Wendy

      <telerik>
        <dataAccess defaultConnection="DefaultConnection">
          <connections>
            <add name="DefaultConnection" driver="Nolics.ORMapper.DataProviders.SqlServer2005Provider"
              connectionStringName="Sitefinity" />
            <add name="GenericContentConnection" driver="Telerik.Cms.Engine.Data.Providers.GCSql2005Provider, Telerik.Cms.Engine.Data"
              connectionStringName="Sitefinity" />
          </connections>
          <cacheDependency mode="InMemory" />
        </dataAccess>
  4. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    13 Feb 2008
    Link to this post
    Hi Wendy Derstine,

    Are you, by any chance upgrading a project created with version 3.0? Please bear in mind that the automatic the automatic upgrade of projects created with Sitefinity 3.0 directly to 3.1 SP2 is not possible because the database and folder structure is now very different (e.g. the ~/Admin folder is now located under ~/Sitefinity/Admin) and there are a lot of changes made to the web.config file.

    In order to give further advice, we need to know the exact Sitefinity version with which the project was created.
    You can check this by opening your project bin folder and checking the version numbers of the Telerik.Cms.dll from the Properties > Version tab.

    Sorry for the additional loop required and thanks for your assistance in advance.

    All the best,
    Rebecca
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  5. Wendy
    Wendy avatar
    14 posts
    Registered:
    07 Jun 2004
    13 Feb 2008
    Link to this post
    Hi,

    This is a brand new installation of Sitefinity.  It may have been something with my SQL installation as I have both SQL 200 and SQL 205 installed on my system.  I created the new database in SQL 2005, but I consistently got error when I selected SQL 2005 in the setup.  I went back in and tried selecting SQL 2000 in the setup on a whim and was able to successfully create the website.  For our purposes of taking a look at the product to see if it will work for us, using SQL 200 is fine at this point.  

    Thanks,

    Wendy

  6. Rebecca
    Rebecca avatar
    536 posts
    Registered:
    24 Sep 2012
    15 Feb 2008
    Link to this post
    Hello Wendy Derstine,

    Thanks for choosing to evaluate our CMS and your feedback. Let us know if you need any assistance.

    Sincerely yours,
    Rebecca
    the Telerik team

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