Print Page | Close Window

Connection Issues

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2010
Forum Discription: For .NET 4.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=2760
Printed Date: 04-May-2025 at 9:42pm


Topic: Connection Issues
Posted By: orcities
Subject: Connection Issues
Date Posted: 13-Jun-2011 at 8:05am
Every morning I come in my BOS is non responsive : "Unable to login: Failed to generate a user instance of SQL Server due to a a failure in starting the process for the user instance. The connection will be closed.
 
Any assistance would be great.


Replies:
Posted By: DenisK
Date Posted: 13-Jun-2011 at 11:00am
Hi orcities;

Have you tried the following steps? 

http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx - http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx

Posted By: orcities
Date Posted: 13-Jun-2011 at 11:01am
I saw that but it doesn't explain which machine to do it on. Do I do it on the server. If so which user. It isn't acceptable to do it on each host machine.

Posted By: DenisK
Date Posted: 13-Jun-2011 at 11:17am
I've tried googling more on this and it seems like you have to do it on the host machine. But I could be wrong. Here's a better write up on the problem.

http://blogs.msdn.com/b/zxue/archive/2010/04/28/fix-sql-server-express-user-instance-connection-error-in-visual-studio-projects.aspx - http://blogs.msdn.com/b/zxue/archive/2010/04/28/fix-sql-server-express-user-instance-connection-error-in-visual-studio-projects.aspx


Print Page | Close Window