More in this section

Forums / Bugs & Issues / Changing the connection string

Changing the connection string

2 posts, 0 answered
  1. Steve
    Steve avatar
    3037 posts
    Registered:
    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"....so 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
    Registered:
    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