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
No comments:
Post a Comment