Microsoft SQL Server

From wikieduonline
Revision as of 07:50, 7 April 2020 by Darkuser (talk | contribs)
Jump to navigation Jump to search

Editions

  • Express: freely downloadable and distributable
  • Standard: includes High Availability 2-node failover cluster
  • Web: under the Microsoft Services Provider License Agreement (SPLA)
  • Enterprise: In-memory ColumnStore, In-memory OLTP, AlwaysOn Availability Groups.
  • Developer edition: licensed for non-production use
  • SQL Server Parallel Data Warehouse

Versions

  • SQL Server 2019
  • SQL Server 2017 RT
  • SQL Server 2016 SP2
  • SQL Server 2014
  • SQL Server 2012

Cloud Services

Upgrade Edition

If you upgraded from SQL Server Express, you must perform additional steps before you can use your upgraded instance of SQL Server:

  • Enable the SQL Server Agent service in Windows SCM.
  • Provision the SQL Server Agent service account by using SQL Server Configuration Manager

More info: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-2016&redirectedfrom=MSDN

Activities

See also

Advertising: