I have tried uninstalling SQL Server 2005 and installing again. Now I get the error response below:

Failed to generate a use instance of SQL Server due to a failure in starting the process for the user interface. The connection will be closed.

This sounds like problems with the OS or installation. These kind of errors are extremely hard for me to fix remotely, so I think you'll need to Google a bit and see what comes up. For the exact error (after I changed use to user) Google returns a couple of interesting results:

http://www.google.com/search?hl=en&q...r+the+user+%22

All with a different solution, so you'll need to figure out which one you need.

Cheers,

Imar


---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of Beginning ASP.NET 3.5 : in C# and VB, ASP.NET 2.0 Instant Results and Dreamweaver MX 2004
Want to be my colleague? Then check out this post.

I am getting the same error message:

Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.

I have installed and reinstalled SQL Server 2005 Express Edition to no avail.

Does the client portion need to be installed?

Thank you

You may want to try reinstalling VWD 2008 as well; if I am not mistaken, it installs a few components needed to integrate with SQL Server. Also, try installing the (Express) edition of the client components. E.g. SQL Server Management Studio Express Edition.

Hope this helps,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!

Areed24, I had much trouble with this. It actually took days for me to get it sorted out. What I finally did was to totally uninstall VWD 2008 Express and SQL Server 2005 Express, including deleting any registry keys associated to them. Then install VWD again, making sure that is completes. SQL Server Mangement Studio will not be included with this install. If you need/want SQL Server Mangement Studio as well, you will need to do an upgrade/Add to your current install. The first time you go through the upgrade process, you will not see the option to add Management Studio. Let this upgrade complete. Then do a second upgrade, and you will see that you now have the option to add SQL Server Management Studio.

Hope this helps.

Thank you, I did a complete uninstall and reinstall as well. Then I received another error message about SQL Not being able to open to which I read up on and found out that the SQLExpress directory needed to be deleted. I think that I am good to go now. Thanks for the additional information.