Share via

SQL Server Express Installtion

Chirag Sachdeva 281 Reputation points
2020-11-08T04:50:12.517+00:00

Hi,

While installing SQL Server Express I am having doubt about below highlighted features, can anyone please help with differences in both these features

"localdb" vs "users are allowed to run a separate instance of the database engine"

38192-image.png

38193-image.png

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,630 questions
0 comments
Accepted answer
  1. Shashank Singh 6,251 Reputation points
    2020-11-08T12:38:03.063+00:00

    The feature sql-server-express-user-instances is deprecated feature and was created for purpose when developers would need own instance of SQL Server without actually having to worry about getting sysadmin access. This feature provided user ablity to run "its own" little SQL Server under actual database engine. But this feature is deprecated from SQL Server 2016. To replace this From SQl Server 2012 LocalDB was bought in. Please read getting-started-with-sql-server-2012-express-localdb for more information about localDb.
    As Erland said please uncheck the box user are allowed to run separate instance of engine

    2 people found this answer helpful.
    0 comments

3 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 109.8K Reputation points MVP
    2020-11-08T12:04:24.42+00:00

    Go with localdb and skip the other one which is a legacy feature. You would only check this one if you have an application that use user instances.

    2 people found this answer helpful.
    0 comments
  2. Cris Zhan-MSFT 6,626 Reputation points
    2020-11-09T03:54:48.017+00:00

    Hi @Chirag Sachdeva ,

    Fully agree with the above answers of the experts. If necessary, please install the LocalDB feature and uncheck the "Users are allowed to run separate instance of the Database Engine" options.(disable the user instance feature)

    SQL Server Express LocalDB should be used in place of the SQL Server Express user instance feature, which was deprecated.

    And please check following articles for the user instance feature and LocalDB:
    SQL Server Express LocalDB
    SQL Server Express User Instances

    Hot issues in October—Users always get connection timeout problem when using multi subnet AG via listener. Especially after failover to another subnet

    1 person found this answer helpful.
    0 comments
  3. Chirag Sachdeva 281 Reputation points
    2020-11-09T16:25:18.417+00:00

    Hi @Cris Zhan-MSFT @Erland Sommarskog @Shashank Singh

    Thank you all for your comments and relevant links. Things are more clear now.

    Regards
    Chirag Sachdeva

    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.