More in this section
Forums / Deployment / Migration SQLExpress to SQL2005 server

Migration SQLExpress to SQL2005 server

The forums are in read-only mode. In case that you want to directly contact the Progress Sitefinity team use the support center. In our Google Plus group you can find more than one thousand Sitefinity developers discussing different topics. For the Stack Overflow threads don’t forget to use the “Sitefinity” tag.
2 posts, 0 answered
  1. Pierre
    Pierre avatar
    433 posts
    16 Feb 2006
    04 Jul 2007
    Link to this post

    It's possible to help-me for migration my Sitefinity database to SQL 2005 production server. How to?

    I'm attached my database to my SQL server 2005
    I'm created a login with id and password for database
    I'm allowed new id in the Sitefinity database and granted for "all" process
    I'm opened ip protocols for connexion on port 1433
    I'm try to connect and have message with problem with string in web.config.

    Send me a sample of connexion string for SQL server 2005 (not express) please.

    When you make video tutorials. How to make?

    Best regards



  2. Slavo
    Slavo avatar
    295 posts
    24 Sep 2012
    04 Jul 2007
    Link to this post
    Hello Pierre,

    I assume that your Sitefinity database is created with SQL Server 2005 Express edition. It uses the same engine as other editions, so you don't really need any changes to the database. After you attach the database, you may want to rename it because by default the standard edition names it with the full path to the MDF file. Find the section <connectionStrings> in web.config and change it with name 'Sitefinity'  to look like this:

      <add name="Sitefinity" connectionString="Data Source=<hostname>; Initial Catalog=<name of database>; user id=<username>; password=<password>;" 
       providerName="System.Data.SqlClient" /> 

    • <hostname> is the name or IP of the machine where your instance of SQL Server is hosted;
    • <name of database> is the name of the Sitefinity database that you have attached;
    • <username> and <password> are the username and password of the SQL server account you have created.
    Here are additional links that may help you when using connection strings:

    There is also a whitepaper on upgrading from SQL Server Express to other editions, which can be found here:

    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
2 posts, 0 answered