{"product_id":"microsoft-sql-server-2017-standard-retail-1-pc","title":"Microsoft SQL Server 2017 Standard Retail [1 PC]","description":"\u003ch2\u003eMicrosoft SQL Server 2017 Standard for Cross-Platform Database Servers\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2017-standard-retail-1-pc\"\u003eMicrosoft SQL Server 2017 Standard\u003c\/a\u003e is the mid-tier relational database management system for line-of-business applications, departmental reporting, and mid-size database servers. The 2017 release is the first SQL Server version to support Linux distributions (Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu) and container deployments alongside the Windows Server edition, broadening deployment options for heterogeneous environments. The release also introduces graph database capabilities, Adaptive Query Processing, and Python integration alongside R. SQL Server 2017 Standard is delivered as a one-time, perpetual license for one Windows Server instance. Activation is a clean one-time step on the target host — the same perpetual product key redeploys the SQL Server 2017 instance on Windows Server, on supported Linux distributions, or in a container without changing the licensing model, so development and operations teams can pick the right platform for each workload. Every SQL Server key is sourced directly from Microsoft authorized channels and delivered to your account dashboard the moment your payment clears, so activation goes through cleanly without invalid-key errors and the same key reactivates on the same server after a rebuild or hardware swap. SQL Server Standard follows Microsoft's per-core plus CAL model: the 1PC license covers the database engine on one server (up to 24 cores per instance), with separate CALs required for each user or device that connects. 🗄️ ⚡\u003c\/p\u003e\n\n\u003ch2\u003eWhat Is Included and How Activation Works\u003c\/h2\u003e\n\u003cp\u003eYour 1PC Retail Online license includes one Microsoft SQL Server 2017 Standard product key that activates the database engine and the core management tools on one Windows Server instance. The license is perpetual, so there are no subscription fees to manage. The same key can be used to reactivate SQL Server 2017 Standard on the same server after a clean reinstall of the operating system or after a hardware refresh.\u003c\/p\u003e\n\u003cp\u003eTo activate, run the SQL Server 2017 Standard installer on the target Windows Server, enter the 25-character product key when prompted, and complete the online activation against the Microsoft activation service. An internet connection is required only for activation and for downloading updates; the database engine runs entirely offline once activated.\u003c\/p\u003e\n\n\u003ch2\u003eKey Features and Capabilities\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRelational database engine\u003c\/strong\u003e — full T-SQL support, stored procedures, triggers, views, and user-defined functions; the engine handles mid-size transactional and analytical workloads on a single Windows Server instance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCross-platform support\u003c\/strong\u003e — run SQL Server 2017 on Windows Server, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, or Ubuntu; the same T-SQL surface and tools work across all supported operating systems.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContainer support\u003c\/strong\u003e — deploy SQL Server 2017 in Docker containers on Windows or Linux, orchestrated by Kubernetes for elastic scale and DevOps workflows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGraph database capabilities\u003c\/strong\u003e — model and query many-to-many relationships with Node and Edge tables alongside relational tables; use the MATCH clause to traverse the graph inside T-SQL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdaptive Query Processing\u003c\/strong\u003e — automatic plan correction, batch mode memory grant feedback, and interleaved execution that improve query performance without manual tuning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity baseline\u003c\/strong\u003e — Always Encrypted, row-level security, Temporal Tables, native JSON, and dynamic data masking carry forward from the 2016 generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlwaysOn availability groups\u003c\/strong\u003e — high availability and disaster recovery with up to two secondary replicas, automatic failover, and readable secondaries for offloading reporting workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIn-memory OLTP and ColumnStore indexes\u003c\/strong\u003e — high-throughput transactional and analytical performance with memory-optimised tables, natively compiled stored procedures, and columnstore indexes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMachine Learning Services\u003c\/strong\u003e — run R and Python scripts inside the database engine for in-database analytics; the standard edition provides a sandboxed runtime for both languages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManagement tools\u003c\/strong\u003e — SQL Server Management Studio (SSMS) on Windows, plus Azure Data Studio as a cross-platform query and notebook editor that works on Windows, macOS, and Linux.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eWho This Edition Is For\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLine-of-business application owners\u003c\/strong\u003e running mid-size departmental databases on a single Windows Server instance with the cross-platform and graph enhancements that SQL Server 2017 introduces.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHeterogeneous IT environments\u003c\/strong\u003e that need a single relational database engine that can run on Windows Server, on Linux, or in containers, managed by the same tools and T-SQL code base.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal IT and database administrators\u003c\/strong\u003e managing SQL Server instances for application development, reporting, and analytics with graph, Adaptive Query Processing, and Python integration as part of the standard feature set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrganisations modernising their data platform\u003c\/strong\u003e for DevOps workflows with container-based deployments, CI\/CD pipelines, and infrastructure-as-code patterns.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eStandard vs Enterprise: What SQL Server Adds\u003c\/h2\u003e\n\u003cp\u003eSQL Server Standard includes the core relational database engine, in-memory OLTP with limited memory, AlwaysOn availability groups with two replicas, ColumnStore indexes, and the security baseline. SQL Server Enterprise adds the features that an organisation needs when the database is large, mission-critical, or both: unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, partitioning, data compression, advanced security features, and the full Machine Learning Services runtime. Big Data Clusters, which combine SQL Server, Spark, and HDFS into a single Kubernetes-based cluster, are an Enterprise-only feature.\u003c\/p\u003e\n\u003cp\u003eFor departmental applications, line-of-business workloads, and small-to-mid-size database servers, Standard is the right fit. For very large databases, mission-critical transactional systems, and analytics at petabyte scale, Enterprise is the typical choice. The perpetual license model means the chosen edition stays available on the licensed Windows Server instance for the lifetime of the installation, with no monthly fees to manage.\u003c\/p\u003e\n\n\u003ch2\u003eCommon Workflows and Use Cases\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eLine-of-business application hosting.\u003c\/strong\u003e SQL Server Standard hosts the database backend for the line-of-business applications that the organisation depends on: ERP, CRM, HR, finance, and the custom in-house tools. Always Encrypted, row-level security, and dynamic data masking (in the 2016 generation and later) protect sensitive data, while AlwaysOn availability groups keep the application online through planned and unplanned outages. SSMS and Azure Data Studio provide the administration, query authoring, and performance tuning tools that the database team needs.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDepartmental reporting and analytics.\u003c\/strong\u003e The combination of SQL Server Standard, SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services provides a complete BI platform for departmental reporting. Power View and PowerPivot (in the 2014 and 2016 generations) and the modern Power BI integration (in the 2017 and 2019 generations) make the analytical output available to business users in self-service mode.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eApplication development and testing.\u003c\/strong\u003e The Standard edition is a common fit for development, test, and staging environments, where the database team needs a faithful reproduction of the production schema and feature set without the Enterprise licensing cost. The Intelligent Query Processing and Accelerated Database Recovery features (in the 2019 generation) reduce the time spent on query tuning and crash recovery, which is valuable in fast-moving development environments.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eMid-size transactional database.\u003c\/strong\u003e For a mid-size transactional database (up to 4 sockets or 16 cores, which is the Standard edition limit), the in-memory OLTP and ColumnStore indexes provide high-throughput transactional and analytical performance. The compatibility levels across SQL Server 2014, 2016, 2017, and 2019 provide a clear migration path to a newer generation when the workload outgrows the current version.\u003c\/p\u003e\n\n\u003ch2\u003eSystem Requirements\u003c\/h2\u003e\n\u003ctable\u003e\n  \u003cthead\u003e\n    \u003ctr\u003e\n\u003cth\u003eComponent\u003c\/th\u003e\n\u003cth\u003eMinimum\u003c\/th\u003e\n\u003cth\u003eRecommended\u003c\/th\u003e\n\u003c\/tr\u003e\n  \u003c\/thead\u003e\n  \u003ctbody\u003e\n    \u003ctr\u003e\n\u003ctd\u003eOperating system\u003c\/td\u003e\n\u003ctd\u003eWindows 10, Windows 8.1, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012 (64-bit editions only)\u003c\/td\u003e\n\u003ctd\u003eWindows Server 2016 or Windows Server 2019 (64-bit)\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eProcessor\u003c\/td\u003e\n\u003ctd\u003ex64 processor at 1.4 GHz or faster\u003c\/td\u003e\n\u003ctd\u003e2.0 GHz or faster, multi-core\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eMemory (RAM)\u003c\/td\u003e\n\u003ctd\u003e1 GB (Express: 512 MB)\u003c\/td\u003e\n\u003ctd\u003e4 GB or more, scaling with database size and workload\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eHard disk space\u003c\/td\u003e\n\u003ctd\u003e6 GB available\u003c\/td\u003e\n\u003ctd\u003eSSD with 20 GB or more for system databases, tempdb, and user data\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eDisplay\u003c\/td\u003e\n\u003ctd\u003eSuper-VGA (800 × 600) or higher\u003c\/td\u003e\n\u003ctd\u003e1280 × 1024 or higher for Management Studio\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003e.NET Framework\u003c\/td\u003e\n\u003ctd\u003e.NET 4.6 or later\u003c\/td\u003e\n\u003ctd\u003e.NET 4.7.2 or later\u003c\/td\u003e\n\u003c\/tr\u003e\n  \u003c\/tbody\u003e\n\u003c\/table\u003e\n\n\u003ch2\u003eActivation and Licensing Notes\u003c\/h2\u003e\n\u003cp\u003eThe 1PC Retail Online key is a perpetual license for Microsoft SQL Server 2017 Standard on one Windows Server instance. The license covers one physical or one virtual instance of the database engine on the server. To run a second named instance on the same server hardware, a second SQL Server 2017 Standard license is required.\u003c\/p\u003e\n\u003cp\u003eSQL Server 2017 Standard supports only 64-bit editions of Windows. 32-bit operating systems are not supported. The cross-platform support in SQL Server 2017 covers Linux distributions and Docker containers, but the Retail Online key activates the Windows Server edition. A separate SQL Server 2017 Standard license for Linux is required for non-Windows deployments.\u003c\/p\u003e\n\n\u003ch2\u003eIntegration with the Microsoft Ecosystem\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2014-standard-retail-1-pc\"\u003eSQL Server 2014 Standard\u003c\/a\u003e integrates with the rest of the Microsoft data platform in well-established ways. SQL Server Management Studio is the administration IDE, and it connects to Analysis Services, Integration Services, and Reporting Services in addition to the relational engine. Power BI can connect to SQL Server 2014 as a data source, which is the recommended path for self-service dashboards built on top of a SQL Server 2014 database. SharePoint 2013 integrates with SQL Server 2014 Reporting Services for SharePoint mode, which lets users view reports inside SharePoint. The .NET Framework and Visual Studio provide the application development path, with the .NET Framework Data Provider for SQL Server and the Entity Framework as the standard data access layer.\u003c\/p\u003e\n\u003cp\u003eThe migration path from SQL Server 2014 to a newer generation is well supported. The database compatibility level 120 is the default for SQL Server 2014, and the engine can be upgraded in place to \u003ca href=\"\/products\/microsoft-sql-server-2016-standard-retail-1-pc\"\u003eSQL Server 2016,\u003c\/a\u003e 2017, or 2019. The Database Migration Assistant and the SQL Server Upgrade Advisor help identify breaking changes and deprecated features before the upgrade begins. For a staged migration, the existing 2014 instance can run side by side with the newer instance, and the data can be moved through transactional replication, log shipping, or AlwaysOn availability groups.\u003c\/p\u003e\n\n\u003ch2\u003eGet Started With Microsoft SQL Server 2017 Standard\u003c\/h2\u003e\n\u003cp\u003eDownload the SQL Server 2017 Standard installer from the Microsoft volume licensing center or a trusted source, run it on the target Windows Server instance, enter your 1PC product key, and follow the installation wizard to select the database engine, management tools, and the optional integration services, reporting services, and analysis services. The SQL Server 2017 Quick Start guide and the Books Online documentation cover the most common administration and performance tuning scenarios. With a perpetual license, your organisation has a stable, professionally supported relational database engine on one Windows Server for as long as the installation remains in service.\u003c\/p\u003e\u003ch2\u003eMicrosoft SQL Server 2017 Standard Alternatives\u003c\/h2\u003e\n\u003cp\u003eThree credible alternatives cover most relational database workloads.\u003c\/p\u003e\n\u003ch3\u003ePostgreSQL\u003c\/h3\u003e\u003cp\u003eFree and open-source relational database with strong JSON support, advanced indexing, and an active community. Best fit for new application development and analytics workloads.\u003c\/p\u003e\u003ch3\u003eMySQL or MariaDB\u003c\/h3\u003e\u003cp\u003eFree and widely supported. Best fit for LAMP-stack web applications and read-heavy workloads.\u003c\/p\u003e\u003ch3\u003eAzure SQL or Amazon RDS for SQL Server\u003c\/h3\u003e\u003cp\u003eManaged cloud versions of SQL Server with automatic patching, backups, and high availability. Best fit when you want to remove operational overhead.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow to choose:\u003c\/strong\u003e Stay on SQL Server for deep Microsoft stack integration, mature tooling, and enterprise features like Always Encrypted, Service Broker, and SQL Server Agent. Choose PostgreSQL for new open-source or analytics workloads. Choose MySQL for simple LAMP web applications. Choose Azure SQL or RDS for managed cloud operation.\u003c\/p\u003e\n\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eWhat is the difference between SQL Server 2017 Standard and Enterprise?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2017 Standard includes the core relational engine, cross-platform support, graph database, Adaptive Query Processing, in-memory OLTP with limited memory, AlwaysOn with two replicas, and basic R and Python integration. SQL Server 2017 Enterprise adds unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, advanced security features, partitioning, data compression, and the full Machine Learning Services runtime.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eCan SQL Server 2017 Standard run on Windows Server 2019?\u003c\/summary\u003e\n  \u003cp\u003eYes. SQL Server 2017 is supported on Windows Server 2019. For new deployments on Windows Server 2022, a newer SQL Server version such as 2019 is recommended.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eHow many cores does the Standard edition support?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2017 Standard supports up to the lesser of 4 sockets or 16 physical cores. SQL Server 2017 Enterprise does not have a socket or core limit within the supported operating system.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eDoes the Standard edition include the graph database features?\u003c\/summary\u003e\n  \u003cp\u003eYes. SQL Server 2017 Standard includes the graph database capabilities (Node and Edge tables, MATCH clause) for modelling and querying many-to-many relationships. The same T-SQL surface and management tools work for graph and relational tables.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eIs internet access required to use the database engine?\u003c\/summary\u003e\n  \u003cp\u003eNo. Once SQL Server 2017 Standard is activated, the database engine runs entirely offline. An internet connection is only required for activation, updates, and the optional Azure hybrid features that SQL Server 2017 introduces.\u003c\/p\u003e\n\u003c\/details\u003e\n\n","brand":"Microsoft","offers":[{"title":"Default Title","offer_id":59850909712465,"sku":"MS-056-MICROSOFT-SQL-SERVER-2017-STANDARD-RETAI","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1059\/0191\/6241\/files\/microsoft-sql-server-2017-standard-retail-1-pc.webp?v=1784725534","url":"https:\/\/dotkeys.net\/products\/microsoft-sql-server-2017-standard-retail-1-pc","provider":"DotKeys","version":"1.0","type":"link"}