difference between SQL server 2014 on Win 8.1 and Windows server

Posted on 2014-08-08
Last Modified: 2014-11-27
dear all,

any one can see the technical diff in function and scare up capability when SQL server 2014 standard/enterprise on Win8.1 and Windows server?
Question by:marrowyung
    LVL 12

    Assisted Solution

    Win 8.1 has a limited amount of users that can connect.  That may affect access to SQL.  Other than that MS recommends installing on Server since Servers can handle more memory & better Processors.
    LVL 34

    Accepted Solution

    standard/developer/express are the only 3 editions supported on windows 8.1
    enterprise edition has clustering capabilities which, of course, can't get in a desktop operating system

    Hardware and Software Requirements for Installing SQL Server 2014

    Editions and Components of SQL Server 2014
    LVL 1

    Author Comment


    what if the win 8.1 box has duel Xeon and 128 GB of RAM ?

    Seth Simmons,

    that answer is good too  ! so I can only use up to standard edition ! standard edition already very good!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Detailed instructions on how to install an Access add-in in recent versions of Office and Windows (with screen shots)
    This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now