Home Forums SQL Server 2005 SQL Server Express Failed to generate a user instance of SQL Server. RE: Failed to generate a user instance of SQL Server.

  • May 14, 2013 at 5:22 am

    #1614935

    What fixed this was connecting to SqlExpress in Visual Studio, Server Explorer - creating a new data connection.

    This re-created the C:\Users\<username>\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory - with default copies of msdb, master and tempdb