SQL Queries

Question

Hai,

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.
Go
Reconfigure

Run this query and then restart the SQL Server.

Step 2. Deleting old files
Now we need to delete any old User Instances.
Go to your C drive and find and completely DELETE this path (and all files inside):

<tt>
</tt> <tt>C:\Documents and Settings\YOUR_USERNAME \Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS</tt>

Urgent!! please

Thanks

 

 

 

 

Answer 1

That means  you can connect to the server but failed to execute queries? To 'delete' instance  you need to uninstall SQL Server instance from control panel

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

C:\Documents and Settings\ is a Windows XP path. The equivalent in Window 7 is C:\Users\

So try C:\users\<username>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty