Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 206
  • Last Modified:

difference between SQL server 2014 on Win 8.1 and Windows server

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?
2 Solutions
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.
Seth SimmonsSr. Systems AdministratorCommented:
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
marrowyungAuthor Commented:

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!

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Tackle projects and never again get stuck behind a technical roadblock.
Join Now