Forums

Skip Navigation LinksHome / Developer Network / Forums / Sitefinity Older Versions (2.x): Installation > Sitefinity 2.6 Primavera demo linked to SQLServer ?

Sitefinity 2.6 Primavera demo linked to SQLServer ?

Feed from this thread
  • Arnaud Vaneste avatar

    Posted on May 16, 2006 (permalink)

    Hi,

    We tried to launch the SiteFinity Primavera example but we get an error :

    ----------------
    Error trying to initialize Membership Services!

    Possible reason:
    You have not set a valid connection string to Membership Services or there are no Membership database objects.

    Solution:
    Set the Membership connection string in the Web.config:
    <connectionStrings>
      <add name = SitefinityMembership
             connectionString = "[Membership Connection string]"
             providerName = "System.Data.SqlClient"
    </connectionStrings>

    To create the Membership database objects in SQL Server Database, run C:\WINDOWS\Microsoft.NET\Framework\<versionNumber>\aspnet_regsql.exe tool. For more information about using aspnet_regsql.exe, refer to http://msdn2.microsoft.com/en-US/library/ms229862.aspx
    ----------------

    I this example linked to SQLServer ?

    Regards,

    Arnaud.

    Reply

  • Arnaud Vaneste avatar

    Posted on May 16, 2006 (permalink)

    Actually, it must be smtg else as we get the same error when creating a new blank project :

    - creation is ok.
    - administration/edit login give this error.

    Note that we use a fresh install on another disk (IIS is on C:, Telerik's files on D:), maybe that's the reason ?

    Thanks for any help,

    Regards,

    Arnaud.

    Reply

  • Vassil Daskalov Vassil Daskalov admin's avatar

    Posted on May 16, 2006 (permalink)

    Hello Arnaud,

    Note that all bare projects(like Primavera) will use the same database configuration (in Sitefinity2.6\Web.config) for Membership users. The default database is located in Sitefinity2.6\App_Data\aspnetdb.mdf. We didn't copy an aspnetdb.mdf file in the Sitefinity2.6\App_Data with the installation, because the ASP will create it on first use, if it does not exist. Also, the default login account is Administrator / admin.

    Be sure that you have SQLexpress edition installed on your computer and if not, change the connection string to use the appropriate membership database. To fit your database to use membership services you can use the apsnet_regsql.exe tool which is located in the windows folder under Microsoft.NET\Framework\v2.0.50727.

    We hope this solves your problem. If not please let us know.

    All the best,
    Vassil Daskalov
    the telerik team

    Reply

  • Arnaud Vaneste avatar

    Posted on May 16, 2006 (permalink)

    Hi Vassil,

    Thanks for answeringso fast ! Telerik support is still terrific :)

    I'll try that & tell you.

    BTW, what if I want to use another DB like Oracle. Is it possible ?

    Thanks again !

    Best Regards,

    Arnaud.

    Reply

  • Vassil Daskalov Vassil Daskalov admin's avatar

    Posted on May 17, 2006 (permalink)

    Hello Arnaud,

    Thank you very much for the nice words. It is a pleasure for us.

    If you want to use another database in Sitefinity like Oracle of Access you can do so but you will also need to have a membership provider supported for those databases or to use a separate SQL database only for the membership information. Currently there are only SQL and Active Directory providers released by Microsoft but if you search the Internet you will most probably find providers for Oracle and Access too. Of course you can implement your own provider by inheriting the MembershipProvider class. More information on this and membership providers you can find in Sitefinity Administration manual as well as here:
    http://msdn2.microsoft.com/en-us/library/f1kyba5e.aspx
    http://msdn2.microsoft.com/en-us/library/sx3h274z(VS.80).aspx

    Have a nice day,
    Vassil Daskalov
    the telerik team

    Reply

  • NickName avatar

    Posted on Jun 7, 2006 (permalink)

    Hi,

     Have downloaded the 30 day trial of the Sitefinity CMS with a view to building it into our next Asp.Net 2.0 application. Unfortunately we have stumbled over the exact same problem as Mr Vaneste. When attempting to view the Primavera example we get the connection string error.

     We have run the RegSql.exe both with the "-A all -E" switches and without (wizard mode). We have a fully created aspnetdb database in the local SQLServer. We have also added:

     <connectionStrings>
      <add name="SitefinityMembership" connectionString="Data Source=CPOOLE;Initial Catalog=aspnetdb;Integrated Security=true;Application Name=Telerik;"
       providerName="System.Data.SqlClient" />
     </connectionStrings>

    to the web.config within the Sitefinity2.6 dir. The IUser account also has full dbo access to the database and full permissions to the Sitefinity directory, and we have tested that the connection string works from Visual Studio.

    I'm hoping this is a simple misunderstanding of the instructions and you can maybe clear this up for us easily.

    Thanks

    Craig Poole
    Internet Application Developer
    First Choice Software

    Reply

  • Vassil Daskalov Vassil Daskalov admin's avatar

    Posted on Jun 7, 2006 (permalink)


    Hello Craig,

    The connection string works in Visual Studio because you are connecting to SQL Server with windows authentication without using the aspnet process. You said you have given permissions to the IUser account which is used by the IIS but this is not necessary due to the fact that IUser uses unmanaged code (IIS is written in C++) which has nothing to do with the aspnet account. All you need to do is to give permissions to the aspnet account in the SQL Server Studio if you have not done it so far.

    Also the statement ApplicationName=telerik; in your connection string is not needed at this time because the application name is read from the membership providers.

    Let us know if this pinpoints your problem.

    Regards,
    Vassil Daskalov
    the telerik team

    Reply

  • NickName avatar

    Posted on Jun 7, 2006 (permalink)

    Thanks for the reply Vassil.

    That has fixed the problem for me. Perhaps this could be mentioed along side the
    'Important
    Give the ASPNET user full permissions for Sitefinity2.6/Projects folders.'
    Comment on the 'Getting Started' page, as I'm sure there will be others who get tripped-up by this.

    Craig

    Reply

  • Vassil Petev Vassil Petev admin's avatar

    Posted on Jun 7, 2006 (permalink)

    Thank you for the feedback, Craig, we will include it in the documentation.


    Regards,
    Rob
    the telerik team

    Reply

Skip Navigation LinksHome / Developer Network / Forums / Sitefinity Older Versions (2.x): Installation > Sitefinity 2.6 Primavera demo linked to SQLServer ?