I posted this in "Visual Studio General" a few days ago, but got no response.
I am running VSTS 2005, and I have Microsoft SQL Server 2005 Developer Edition installed on my machine. I would now like to create an application that has its own database file (.mdf) included. From within my VS project, I go to "Add New Item". I select "SQL Database", put in the name, and hit [Add]. At that point I get a message box with the title "Local database file", saying "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." Any ideas of what I'm doing wrong? Do I need SQL Server 2005 Express installed in addition to Developer Edition?
It's quite possible that this is well documented, or that I have a simple configuration set wrong, or that I'm doing something fundamentally wrong, and that all I need to do is RTFM, but despite searches, I couldn't find anything that addressed this directly. Can someone point me in the right direction? Also, if there's a better forum to post this to, please let me know.
Thanks!
Brad.
moved to the SQL forum|||User instances are a feature of SQL Server Express, so you'll need to install SSE in addition to your Developer Edition instance to use this feature in Visual Studio.
Hope this helps,
Steve
