Getting error in visual studio 2008 sp1 while creating .mdf file in app_data folder and error is "Failed to generate a user instance of SQL Server due to a failure in starting the process for the...

Question

1.00/5 (1 vote)

See more:

Getting error in visual studio 2008 sp1 while creating .mdf file in app_data folder in sqlexpress and error is
"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."
I have tried by deleting sqlexpress folder from the following path
"Windows XP: C:\Documents and Settings\YOUR_USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS"

But it doesn't work for me please need help

Posted 14-May-13 23:10pm

Member 9793793

Add a Solution

Comments

Thanks7872 15-May-13 6:51am

Have you restarted your system after deleting the folder?

Member 9793793 15-May-13 7:19am

yes i have restarted but nothing happen it shows the same error

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Thanks7872 · Answer 1 · 2013-05-15T01:36:00

Solution 1

Go to Query Window in SQL Server Management Studio and type this:

exec sp_configure 'user instances enabled', 1. <br />
Go<br />
Reconfigure

Run this query and then restart the SQL Server.

Posted 15-May-13 1:36am

Thanks7872

Comments

Member 9793793 15-May-13 8:10am

can u tell me exact location or how to Go to Query Window in SQL Server Management Studio.

Thanks7872 15-May-13 8:15am

Start Sql server mngmt studio,on top left corner you will find NEW QUERY window.Write the above code and click ! symbol to execute it.

Thanks7872 15-May-13 8:17am

Also try using User Instance = false in your connection string.

Member 9793793 15-May-13 8:43am

it doesn't work getting same error

Thanks7872 15-May-13 23:57pm

Refer to this link