Visual Studio C# 2012, MS Sql Server Express 17

Scott Hamlin 1 Reputation point
2020-08-23T00:37:19.257+00:00

OK Folks, I've been developing code in Visual Studio C# V12, using MS Sql Server Express V2017 for a year.
-No Problems. Code compiled, and I could test and deploy code.
-I added a database in MS Sql Server Express V2017 -total unrelated to my previous DB, and Development Environment, and now I receive, "Failure to start a user instance of Sql Server due to a failure of starting the process for the user.
Upon one recommendation -I stopped the Sql Server Instance Process, and deleted all files in the '%LOCALAPPDATA%\Microsoft\Microsoft Sql Server Data\SQLEXPRESS' folder
Rebooted, to restart the processes -and received the same error message.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,688 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AmeliaGu-MSFT 13,976 Reputation points Microsoft Vendor
    2020-08-24T06:42:26.497+00:00

    Hi ScottHamlin-8323,

    Could you please try to change SQL Server Service account to Local System in SQL Server Configuration Manager->SQL Server Express instance properties->Log On tab? Please refer to this blog which might help.
    In addition, you can add Visual Studio tag so that people there will help you more effectively.

    Best Regards,

    Amelia

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.