Home ›
ASP.NET Forums » General ASP.NET » Installation and Setup » Cannot Create a database in Visual Web Developer 2008 Express

Cannot Create a database in Visual Web Developer 2008 Express

Last post 07-06-2009 3:48 PM by jeff@zina.com. 2 replies.

Sort Posts:

  • Cannot Create a database in Visual Web Developer 2008 Express

    07-05-2009, 5:48 PM
    • Member
      13 point Member
    • Alie
    • Member since 06-30-2009, 8:33 PM
    • Liberia
    • Posts 25

    Hi Friends,

    I have just installed Visual Web Developer 2008 Express on my laptop (with x64 OS Architecture). During the installation, I made the choice to install SQL Server 2008 x64. After the installation, I am trying to create a database in Visual Web Developer. This is what I did exactly:

    1. Right Clicked on the App_Data folder 

    2. Clicked on Add new Item

    3. Selected SQL Server Database

    4. Clicked add


    This error comes up: Failed to generate a user instance of SQL Server due to failure in starting the process for the user instance. The connection will be closed.

    I thought its because I did not start VWD as an Administrator; so I closed it and then ran as Administrator, but it still gives the same error. I then try to start the SQL Server Browser process but it still reads error


    Please help me solve this problem.


    M. Alie Pussah, II
    God's Chosen

  • Re: Cannot Create a database in Visual Web Developer 2008 Express

    07-05-2009, 11:22 PM
    • Member
      276 point Member
    • scngan
    • Member since 04-21-2006, 3:55 AM
    • Posts 63

    when you install the sql server, you start it with which account ? network services or local system ?

    if not mistaken, you need to install as local system.... 

    *** Please remember to click "Mark as Answer" on this post if it helped you ***

    http://blog.scnetstudio.com

  • Re: Cannot Create a database in Visual Web Developer 2008 Express

    07-06-2009, 3:48 PM
    Answer
    • All-Star
      77,729 point All-Star
    • jeff@zina.com
    • Member since 09-26-2003, 10:43 AM
    • Naples, FL, USA
    • Posts 10,566
    • Moderator
      TrustedFriends-MVPs

    User instanaces are a pain.  This thread has most of the possible solutions and work arounds:

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/f5eb164d-9774-4864-ae05-cac99740949b

    Jeff

    Blatant Self Promotion: ASP.NET 3.5 CMS Development
Page 1 of 1 (3 items)
RSS Available

Contact | Advertise | Issue Management by Axosoft's OnTime | Running IIS7
All Rights Reserved. | Terms of Use | Trademarks | Privacy Statement
© 2009 Microsoft Corporation.