More in this section

Forums / Set-up & Installation / issue with sqlexpress 2008 on vista

issue with sqlexpress 2008 on vista

3 posts, 0 answered
  1. Daniel
    Daniel avatar
    3 posts
    08 Nov 2008
    19 Nov 2008
    Link to this post
    receiving the error:

    Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.

    when i get the error while creating a project it states the source:

    Line 87:         <clear />
    Line 88:         <add connectionStringName="DefaultConnection" applicationName="/"
    Line 89:           name="Sitefinity" type="Telerik.DataAccess.AspnetProviders.TelerikRoleProvider, Telerik.DataAccess" />
    Line 90:       </providers>
    Line 91:     </roleManager>

    when I get the error when trying to view the university  it states the source

    An unhandled exception was generated during the execution of the current web request.

    either way I cannot connect.
  2. Daniel
    Daniel avatar
    3 posts
    08 Nov 2008
    20 Nov 2008
    Link to this post
    I uninstalled sqlexpress  2008 and installed sqlexpress 2005 and am still experiencing the same issues.  Any help would be apreciated.
  3. Pepi
    Pepi avatar
    981 posts
    31 Jan 2017
    20 Nov 2008
    Link to this post
    Hello Daniel,

    The error you get "Failed to generate a user instance..." doesn't look like a Sitefinity error. It may be caused because a previous install of SQL Express has left files. Or the problem might be with your SQL configuration.  Please take a look at these links:

    Also, do you have other web applications, which are using SQL Express and are working fine? Please, check the name of your SQLExpress instance (by default it is SQLEXPRESS)? If the instance is different, you need to modify the connection string:

        <add name="Sitefinity" connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Sitefinity.mdf" providerName="System.Data.SqlClient"/> 

    If the information above does not help, I would suggest you install Microsoft SQL Server Management Studio Express and do the following:

    1. Create the database.
    2. Set the account that runs the ASPNET working process (this is the NETWORK SERVICES account in IIS6.x) to your database as db_owner.
    3. At the "Set Database" wizard step (when creating the project), enter the database connection settings.

    Do let us know how it goes.

    the Telerik team

    Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Register for webinar
3 posts, 0 answered