1)db explorer-->data connections right click and selected add connection
2)in next window i selected data source as Microsoft SQL Server Database File (SqlClient)
3)in database name i gave some name like db after tat i pressed k button... it asked for conformation message as database file does not exist would u like to create i selected yes but it shows error as
failed to generate a user instance of sql server due to failure in starting the process for the user instance. the connection will be closed
could anyone solve my prob its very urgent......
Santhosh Kumar JayaramanPosted Oct 19, 2012, 8:06 AM
Santhosh Kumar JayaramanPosted Oct 19, 2012, 6:12 AM
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):
C:\Documents and Settings\YOUR_USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS(Dont forget to replace the green text in the path with your current username (if you are not sure just go to C:\Documents and Settings\ path to figure it out).
After deleting this dir you can go to Visual Studio, create ASP.NET WebSite and click on your App_Data folder and chooseAdd New Item and then choose SQL Server Database and it should work!!!
http://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
selva kumarPosted Oct 19, 2012, 7:57 AM