Unable to start SQL Server instance
Sometimes, we used to face the below error while trying to restart the database services or during login with a specific user credentials.
"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."
It's due to a setting in SQL Server. User instance in SQL Server is not enabled. Enter into your database with administrative access possibly windows account.
Step 1: Enabling User Instances on your SQL Server installation
First, you need to enable User Instances for SQL Server installation.
Query Window in SQL Server Management Studio and execute the below query
exec sp_configure 'user instances enabled', 1
Go
Reconfigure
Restart the SQL Server.
Step 2:
We need to delete all the old User Instances.
Go to your C drive search for the below path,
C:\Documents and Settings\YOUR_USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
Step3: Restart your machine. If the above steps didn't resolve your issue.
Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/