to fix the problem of sqldumber.exe

Question

i have a C# project but when i add the new item sqldatabase(.mdf) file in project.
it does not add and a error is occured
error

Failure to generate a user instance of sql server due to failure in starting the process of user instance

please reply

keshav singh · Answer

iam using sql 2000. when i run your command in query analyzer it gives error thatit it does not contain configuration or advanced option reply

Lalit M · Answer

try this steps 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): 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 choose Add New Item and then choose SQL Server Database More options ------------- Check your connection String