Post reply

MVC Architecture using Sql Server Express

  • January 1, 2009 at 11:32 pm

    #197643

    hi friends,

    First of all belated HAPPY NEW YEAR.

    i am working with ASP.Net MVC Architecture.while i am trying to add SQL Server Express database through APP_Data i am getting following error.

    error: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

    if any body knows please help me.

    Thanks in advance,

    cheers,

    ram.

  • January 23, 2009 at 5:04 am

    #931721

    Is there a special reason for using user instances?

    If you cannot avoid using them, make sure the "user instance enabled" option is set for the SQL Server Express instance (look it up in Books Online).

    If there aren't any rational reasons for using user instances, simply don't use them (i.e. don't use the "user instance" argument in the connection string or don't set it to true).

    ML

    ---
    Matija Lah, SQL Server MVP
    http://milambda.blogspot.com

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply