SQL Express and VB.NET Express Editions

I am trying to add a data connection with one of my databases in sql express and I keep getting the following error message

"Failed to generate a user instance of sql server due to failure in starting a process for the user instance. The connection will be closed"

How do I go about resolving this.

Thanks

Floorcookie
I don't see where there is an sql server portion of vb.net express to be installed
Narendra
Hi,

I found this post http://forums.microsoft.com/msdn/showpost.aspx postid=98346&siteid=1. Please see if the answer fixes your issue.

Have you tried asking this question in SQL Server Database Engine http://forums.microsoft.com/MSDN/ShowForum.aspx ForumID=93&SiteID=1

Best regards,
yulia_o
Hi

I encounter this "User Instance of SQL Server" problem when deploying by using ClickOnce. I posted my question here in detail : http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=340802&SiteID=1

Any help would be very much appreciated.

Thanks.
Sumit Kute
kgs1951,

Thanks for the question. Sql Server Express (SSE) is an optional part of the VB.Net Express install. To check if you have it open your start menu and look for an entry called "Microsoft SQL Server 2005". If you do not have that node then you likely did not install SSE. You can download SSE from http://msdn.microsoft.com/vstudio/express/sql/download/default.aspx

Hope this helps,

Kris
Barry Hagan
SQL express was installed. I am able to make changes and run scripts with SQL server management tool

Ken
JohnDeHope3
Sounds like somthing is not installed correctly. Did you install the sql server portion of vb express (if it has it)
SQL Express and VB.NET Express Editions