I need urgent help
I am able to use the sql server and execute queries as well
however, When I try to use sql server database in asp.net or windows form, it says the following 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."
Some steps in the forum, but I'm unable to execute the 2nd steps as I could not find the
<tt>C:\Documents and Settings</tt>
setting although I re-configured using first step 1step
Step 1. Enabling User Instances on your SQL Server installation
First we are gonna make sure we have enabled User Instances for SQL Server installation.
Go to Query Window in SQL Server Management Studio and type this:
exec sp_configure 'user instances enabled', 1.
Run this query and then restart the SQL Serve
View Complete Post