More in this section
Forums / Bugs & Issues / Changing the connection string

Changing the connection string

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. Steve
    Steve avatar
    3037 posts
    03 Dec 2008
    02 Feb 2011
    Link to this post
    Ok, so if you connect with connection string 1, with the user "steve", and you've used that to do all your development...

    Then lets say you move servers and the login is now "sa" you update the details

    OpenAccess regenerates ALL the tables again, so my DB is 1/2 DBO.TABLE1, STEVE.TABLE1

  2. Nikolay Datchev
    Nikolay Datchev avatar
    87 posts
    01 Nov 2016
    08 Feb 2011
    Link to this post
    Hi Steve,

    I am afraid this is related to the standard SQL server behavior. The whole db structure is created from scratch when sitefinity initializes for the first time. If the user that you used to connect and create the database wasn't a db owner, all the tables are automatically created with this user schema. If the initial user was dbowner they would have been with DBO schema. I guess your current option is to either somehow convert back to this initial user for the connection, or migrate the existing tables to the DBO schema, using ALTER SCHEMA statements. We are going to consider the option of forcing the tables to be created always in the DBO schema to avoid such problems.

    Kind regards,
    Nikolay Datchev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
2 posts, 0 answered