I have verified that the service is running. The service is listed as
SQL Server (SQLEXPRESS)
This time I installed sql server 2008 R2 express with all the default settings.
Now, when I attempt to add a sql data source in visual web developer, I am getting:
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.
So it sounds to me like visual web recognized that I do in fact have SQL installed and running as a process on my machine. What does it mean by "User instance"?
Believe it or not I got it working. I followed the advice on
After my new install, I had to make sure the process was started with LocalService, which it wasn't, then I had to manually delete a folder
in my user's appdata called sqlserverexpress, which apparently was holding some incorrect data from previous installs.
I believe that the installer should handle this for the end user.
Now I have added your recipes.mdf file to my project and can continue with the lesson!!
BTW Toi, is there a quick way to determine a correct connection string, does Visual Studio have a way to find it?