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

Forums / Deployment / Migration SQLExpress to SQL2005 server

Migration SQLExpress to SQL2005 server

2 posts, 0 answered
  1. Pierre
    Pierre avatar
    433 posts
    Registered:
    16 Feb 2006
    04 Jul 2007
    Link to this post

    Hi,
    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
    Registered:
    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:

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


    Where:
    • <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:
    http://msdn2.microsoft.com/en-us/library/ms722656.aspx
    http://builder.com.com/5100-6371_14-6084879.html

    There is also a whitepaper on upgrading from SQL Server Express to other editions, which can be found here:
    http://download.microsoft.com/download/E/8/B/E8B42814-6A0C-40EB-911F-E7ADEC87F5D5/UpgrExptoWkgStd.doc


    Greetings,
    Slavo
    the Telerik team

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