Reply

AngelRose

Member

26 Points

47 Posts

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

Jul 19, 2012 12:25 PM|LINK

I am trying to deploy my application, but it gives me the following error on login,.. plz help!

Server Error in '/' Application.

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.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: 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.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[SqlException (0x80131904): 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.]
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064458
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +35
   System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, SqlConnection owningObject) +183
   System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, TimeoutTimer timeout) +239
   System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, TimeoutTimer timeout, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +195
   System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +232
   System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +5078107
   System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +33
   System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +524
   System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66
   System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +479
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +108
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +126
   System.Data.SqlClient.SqlConnection.Open() +125
   System.Web.DataAccess.SqlConnectionHolder.Open(HttpContext context, Boolean revertImpersonate) +95
   System.Web.DataAccess.SqlConnectionHelper.GetConnection(String connectionString, Boolean revertImpersonation) +206
   System.Web.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Boolean updateLastLoginActivityDate, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved, DateTime& lastLoginDate, DateTime& lastActivityDate) +827
   System.Web.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat) +105
   System.Web.Security.SqlMembershipProvider.ValidateUser(String username, String password) +106
   System.Web.UI.WebControls.Login.AuthenticateUsingMembershipProvider(AuthenticateEventArgs e) +60
   System.Web.UI.WebControls.Login.OnAuthenticate(AuthenticateEventArgs e) +129
   System.Web.UI.WebControls.Login.AttemptLogin() +127
   System.Web.UI.WebControls.Login.OnBubbleEvent(Object source, EventArgs e) +101
   System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +37
   System.Web.UI.WebControls.Button.OnCommand(CommandEventArgs e) +125
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +167
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

Reply

tdykstra

Contributor

4432 Points

620 Posts

Microsoft

Moderator

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

Jul 19, 2012 02:43 PM|LINK

What does your connection string look like in the deployed site -- did you leave User Instance=True in it? You generally don't use SQL Express in a production site, and User Instance applies only to Express.

Reply

AngelRose

Member

26 Points

47 Posts

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

Jul 19, 2012 02:48 PM|LINK

This is the connection string, my database seems to be connected in VS but after deployment , when i try to login to my application, this error occurs

Edited by AngelRose on Jul 19, 2012 02:49 PM

Reply

tdykstra

Contributor

4432 Points

620 Posts

Microsoft

Moderator

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

Jul 19, 2012 02:53 PM|LINK

Are you publishing to a hosting provider that runs SQL Server Express in production? Typically you need to set up a regular SQL Server database in production and deploy to that, then change the connection string when you deploy.

Reply

AngelRose

Member

26 Points

47 Posts

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

Jul 19, 2012 03:01 PM|LINK

no i am trying to deploy it on IIS 7.5 but it doesnt work

Reply

Ruchira

All-Star

42887 Points

7020 Posts

MVP

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

Jul 20, 2012 01:36 PM|LINK

Hello,

Have you tried by Google/Bing your error? If not, please check the below links

Specially check the below thread if it only happens in IIS.

http://blogs.iis.net/webdevelopertips/archive/2010/05/06/tip-106-did-you-know-how-to-solve-the-errors-when-aspnetdb-mdf-is-created-dynamically-with-iis.aspx

Check below too.

http://forums.asp.net/t/1377174.aspx/3/10

http://social.msdn.microsoft.com/forums/en-US/sqldatabaseengine/thread/527bf46a-b3fe-4ae6-8b41-eb40024399c8/

http://stackoverflow.com/questions/4770596/failed-to-generate-a-user-instance-of-sql-server-due-to-failure-in-retrieving-th

http://p2p.wrox.com/book-beginning-asp-net-3-5-c-vb-book-isbn-978-0-470-18759-3/76945-chapter-18-getting-failed-generate-user-instance-sql-server-error.html

http://mywsat.codeplex.com/discussions/211246/

Please 'Mark as Answer' if this post helps you.

My Tech blog | My YouTube Channel

Edited by Ruchira on Jul 20, 2012 01:38 PM
Marked as answer by Dino He - MSFT on Jul 26, 2012 02:26 AM

Reply

TitoM

Member

2 Points

1 Post

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

Aug 02, 2012 09:32 AM|LINK

Hi, I'm actually having the same problem, if you find the solution please post it

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. RSS

6 replies

AngelRose

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

Server Error in '/' Application.

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.

tdykstra

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

AngelRose

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

tdykstra

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

AngelRose

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

Ruchira

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

TitoM

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

This site is managed for Microsoft by Neudesic, LLC. | © 2013 Microsoft. All rights reserved.

Follow Us On:

Microsoft