Forums

Skip Navigation LinksHome / Developer Network / Forums / Sitefinity Older Versions (2.x): Installation > Error trying to initialize Membership Services!

Error trying to initialize Membership Services!

Feed from this thread
  • Angel L Vazquez avatar

    Posted on Oct 19, 2006 (permalink)

    I just installed Sitefinity locally on my dev machine using an external SQL Server 2000 db, created my project , when I go to edit I get the error: Error trying to initialize Membership Services! 

    I set the project to create the member tables in the same database, what am I missing?

    Reply

  • Paul Kavanagh avatar

    Posted on Jan 25, 2007 (permalink)

    Similar issue. I have a portal that is working fine. I need to create another portal that is very similar, so I tried the following:
     - copy code into new folder, create iis site pointing to that folder
     - copy db from original portal into a new db
     - modify web.config file in new portal to point to new database (both places in web.config were changed, verified that login works against the new database)

    I get the aforementioned error. Should I be able to do what I am trying to do? Any ideas on what is wrong?

    Thanks!!

    Paul

    Reply

  • Hrisi Hrisi admin's avatar

    Posted on Jan 26, 2007 (permalink)

    Hello Paul,

    From your question it is not clear which Sitefinity version and what kind of database is used. Nevertheless, I would like to mention some important details about  project configuration.
    Sitefinity relies on a well configured db. This mean the following:
    • for file based databases such as Access, the ASPNET process should have r/w permissions for the folder containing the db file;
    • for SQL Server you should check if all db objects, related to Sitefinity and Membership services have dbo as owner. As a result, login from Web.config should work with all objects.

    If you have any specific info for your project, please tell us to further clarify the initial project configuration.

    Best wishes,
    Hrisi
    the telerik team

    Reply

  • Paul Kavanagh avatar

    Posted on Jan 26, 2007 (permalink)

    The version is 2.7.1. The database is sql server. To copy the database, I did a restore on the database that is used for the existing working copy of sitefinity. So, all of the objects, permissions, logins, etc., are exactly the same. I also verified this my manually logging into the db using the login info specified in the connections strings of the web.config of the working copy, and by looking at the new database to ensure that all objects are there. All objects have dbo as owner.

    So, as far as I can tell, other than having a different db name, the two databases are exactly identical.

    Reply

  • Hrisi Hrisi admin's avatar

    Posted on Jan 26, 2007 (permalink)

    Hello Paul,

    One possible reason is a different SQL Server login account and database user account. Restoring the database  restores only the database user account and for SQL Server 2000 there is no way to create a login account from a user account (map user to login). You should create a new login account, grant the access rights to the Sitefinity project database and make it a db_owner. After that, change in your Web.config, UID/PWD with the login account info in both places.

    If you are using an SQL Server connection with windows authentication, probably the ASPNET account does not have permissions for the database: there is no impersonation and the account which is trying to connect to the database is the ASPNET account. So please, make sure that the ASPNET account has permissions to the database. Don't forget to restart the ASP.NET application so that changes take effect.

    You can find more details about "Error Trying to initialize Membership Services" in this KB article.

    Sincerely yours,
    Hrisi
    the telerik team

    Reply

  • Paul Kavanagh avatar

    Posted on Jan 26, 2007 (permalink)

    Thanks! Ug... I recopied the web.config from the original instance, change the db name (I had already added the correct login to the DB) and voila! I must have had an error in the webconfig or something along those lines. Have to remember, simplest things first.

    Anyway, thank you for the help.

    Paul

    Reply

Skip Navigation LinksHome / Developer Network / Forums / Sitefinity Older Versions (2.x): Installation > Error trying to initialize Membership Services!