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

Forums / Developing with Sitefinity / Sitefinity 4.4 migrate from SQLEXPRESS to SQLSERVER

Sitefinity 4.4 migrate from SQLEXPRESS to SQLSERVER

4 posts, 0 answered
  1. Elsane
    Elsane avatar
    30 posts
    Registered:
    06 Jan 2012
    06 Apr 2012
    Link to this post
    Hi,

    We worked with SQLEXPRESS and attachedFile functionality for development step. For the production environment we wanted to migrate under SQLSERVER 2008 R2.

    As SQLSERVER does not support attached file functionnality we created a "real" database from the database file. Next we tried to change the connection string and here is our problem : whatever value we set the connection string, it seems sitefinity always try to work from the database file.

    Here is our cconnection string : Server=.\SQLSERVER;Database=sitefinity;Integrated Security=SPPID

    And the associated error when we try to visit our website : "The user instance login flag is not supported on this version of SQL Server".

    We tried to add "User Instance=false" to the connection string without result, we tried to user a SQL authentification instead of windows authentification... same thing : always the same error.

    We tried to create a new Sitefiniy project, if we specify a new database in the sartup option sitefinity create the database and use it but there is no connection string in the web.config. If we specify an existing database it doesn't work and create a database file under app_data. If we create a database in a new project, next delete these database in SQLServer management studio then import an existing sitefinity database we have errors with the custom modules created from the moduleBuilder.

    We cannot just re-enter all the site content. So, how can we do ?

    Thank you.
  2. Tim
    Tim avatar
    258 posts
    Registered:
    22 Jun 2011
    06 Apr 2012
    Link to this post
    Elsane,

    One thing to look at is going to be what's contained in "/App_Data/Sitefinity/Configuration/DataConfig.config".

    Also, if you really want to use the web.config for the configuration. Check out the "Make Sitefinity use the web.config for the database connection string" section of this blog post. It'll also give some insight as to how that whole "connection strings in different files" works.

    Hope that helps!
  3. SelAromDotNet
    SelAromDotNet avatar
    912 posts
    Registered:
    18 Jul 2012
    06 Apr 2012
    Link to this post
    as Tim said the DataConfig.config file is the location of the Sitefinity connection string. I would like to add that when you modify this file, to also re-save the web.config to restart the website as I believe all the configurations are cached on startup.
  4. Elsane
    Elsane avatar
    30 posts
    Registered:
    06 Jan 2012
    10 Apr 2012
    Link to this post
    Thanks to both of you. It's exactly what I was looking for !
4 posts, 0 answered