c# - What are in SQL Server User Instances that make them impossible in non-Express Editions? -
    after developing few years (or more), still not understand:     what makes user instances impossible/incompatible developer (or other) edition of sql server?       why has developer install more 1 (i.e. developer edition) of sql server because user instances available through express edition?       update: @damien_the_unbeliever wrote in answer,    "user instances pretty expected standalone databases, used single application, , meaningless without application."     do understand correctly user instances:      require sql server express setup  cannot connected remotely  the user cannot have more 1 such instance?   the client apps connect them dev tools vs, ssms, webadmin, sql express utility , etc?     really not understand when/why/how can used/deployed outside of development environment   what non-dev cases of sql server user instances (vs ce , other embedded databases)?          i don't believe there technical reasons why user instance functionality couldn't exi...