Windows 2012 Server is an example of which of the following are categories
Amazon RDS supports several versions and editions of Microsoft SQL Server. The most recent supported version of each major version is listed here. For the full list of supported versions, editions, and RDS engine versions, see . Show
For information about licensing for SQL Server, see Licensing Microsoft SQL Server on Amazon RDS. For information about SQL Server builds, see this Microsoft support article about the latest SQL Server builds. With Amazon RDS, you can create DB instances and DB snapshots, point-in-time restores, and automated or manual backups. DB instances running SQL Server can be used inside a VPC. You can also use Secure Sockets Layer (SSL) to connect to a DB instance running SQL Server, and you can use transparent data encryption (TDE) to encrypt data at rest. Amazon RDS currently supports Multi-AZ deployments for SQL Server using SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs) as a high-availability, failover solution. To deliver a managed service experience, Amazon RDS does not provide shell access to DB instances, and it restricts access to certain system procedures and tables that require advanced privileges. Amazon RDS supports access to databases on a DB instance using any standard SQL client application such as Microsoft SQL Server Management Studio. Amazon RDS does not allow direct host access to a DB instance via Telnet, Secure Shell (SSH), or Windows Remote Desktop Connection. When you create a DB instance, the master user is assigned to the db_owner role for all user databases on that instance, and has all database-level permissions except for those that are used for backups. Amazon RDS manages backups for you. Before creating your first DB instance, you should complete the steps in the setting up section of this guide. For more information, see Setting up for Amazon RDS. Common management tasks for Microsoft SQL Server on Amazon RDSThe following are the common management tasks you perform with an Amazon RDS for SQL Server DB instance, with links to relevant documentation for each task. There are also advanced administrative tasks for working with SQL Server DB instances. For more information, see the following documentation: Limitations for Microsoft SQL Server DB instancesThe Amazon RDS implementation of Microsoft SQL Server on a DB instance has some limitations that you should be aware of:
DB instance class support for Microsoft SQL ServerThe computation and memory capacity of a DB instance is determined by its DB instance class. The DB instance class you need depends on your processing power and memory requirements. For more information, see DB instance classes. The following list of DB instance classes supported for Microsoft SQL Server is provided here for your convenience. For the most current list, see the RDS console: https://console.aws.amazon.com/rds/. Not all DB instance classes are available on all supported SQL Server minor versions. For example, some newer DB instance classes such as db.r6i aren't available on older minor versions. You can use the describe-orderable-db-instance-optionsAWS CLI command to find out which DB instance classes are available for your SQL Server edition and version. SQL Server edition2019 support range2017 and 2016 support range2014 support range Enterprise Edition
Standard Edition
Web Edition
Express Edition
Microsoft SQL Server securityThe Microsoft SQL Server database engine uses role-based security. The master user name that you specify when you create a DB instance is a SQL Server Authentication login that is a member of the Any user who creates a database is assigned to the db_owner role for that database and has all database-level permissions except for those that are used for backups. Amazon RDS manages backups for you. The following server-level roles aren't available in Amazon RDS for SQL Server:
The following server-level permissions aren't available on RDS for SQL Server DB instances:
Compliance program support for Microsoft SQL Server DB instancesAWS Services in scope have been fully assessed by a third-party auditor and result in a certification, attestation of compliance, or Authority to Operate (ATO). For more information, see AWS services in scope by compliance program. HIPAA support for Microsoft SQL Server DB instancesYou can use Amazon RDS for Microsoft SQL Server databases to build HIPAA-compliant applications. You can store healthcare-related information, including protected health information (PHI), under a Business Associate Agreement (BAA) with AWS. For more information, see HIPAA compliance. Amazon RDS for SQL Server supports HIPAA for the following versions and editions:
To enable HIPAA support on your DB instance, set up the following three components. ComponentDetails Auditing To set up auditing, set the parameter Transport encryption To set up transport encryption, force all connections to your DB instance to use Secure Sockets Layer (SSL). For more information, see . Encryption at rest To set up encryption at rest, you have two options:
SSL support for Microsoft SQL Server DB instancesYou can use SSL to encrypt connections between your applications and your Amazon RDS DB instances running Microsoft SQL Server. You can also force all connections to your DB instance to use SSL. If you force connections to use SSL, it happens transparently to the client, and the client doesn't have to do any work to use SSL. SSL is supported in all AWS Regions and for all supported SQL Server editions. For more information, see Using SSL with a Microsoft SQL Server DB instance. Microsoft SQL Server versions on Amazon RDSYou can specify any currently supported Microsoft SQL Server version when creating a new DB instance. You can specify the Microsoft SQL Server major version (such as Microsoft SQL Server 14.00), and any supported minor version for the specified major version. If no version is specified, Amazon RDS defaults to a supported version, typically the most recent version. If a major version is specified but a minor version is not, Amazon RDS defaults to a recent release of the major version you have specified. The following table shows the supported versions for all editions and all AWS Regions, except where noted. You can also use the Major versionMinor versionRDS API 15.00.4236.7 (CU16) 15.00.4198.2 (CU15) 15.00.4153.1 (CU12) 15.00.4073.23 (CU8) 15.00.4043.16 (CU5)
14.00.3451.2 (CU30) 14.00.3421.10 (CU27) 14.00.3401.7 (CU25) 14.00.3381.3 (CU23) 14.00.3356.20 (CU22) 14.00.3294.2 (CU20) 14.00.3281.6 (CU19)
13.00.6419.1 (SP3 + Hotfix) 13.00.6300.2 (SP3)
12.00.6439.10 (SP3 CU4 SU) 12.00.6433.1 (SP3 CU4 SU) 12.00.6329.1 (SP3 CU4) 12.00.6293.0 (SP3 CU3)
Version management in Amazon RDSAmazon RDS includes flexible version management that enables you to control when and how your DB instance is patched or upgraded. This enables you to do the following for your DB engine:
Microsoft SQL Server engine patching in Amazon RDSAmazon RDS periodically aggregates official Microsoft SQL Server database patches into a DB instance engine version that's specific to Amazon RDS. For more information about the Microsoft SQL Server patches in each engine version, see . Currently, you manually perform all engine upgrades on your DB instance. For more information, see Upgrading the Microsoft SQL Server DB engine. The following table displays the planned schedule of deprecations for major engine versions of Microsoft SQL Server. Microsoft SQL Server features on Amazon RDSThe supported SQL Server versions on Amazon RDS include the following features. In general, a version also includes features from the previous versions, unless otherwise noted in the Microsoft documentation. Microsoft SQL Server 2019 featuresSQL Server 2019 includes many new features, such as the following:
For the full list of SQL Server 2019 features, see What's new in SQL Server 2019 (15.x)in the Microsoft documentation. For a list of unsupported features, see . Microsoft SQL Server 2017 featuresSQL Server 2017 includes many new features, such as the following:
For the full list of SQL Server 2017 features, see What's new in SQL Server 2017in the Microsoft documentation. For a list of unsupported features, see . Microsoft SQL Server 2016 featuresAmazon RDS supports the following features of SQL Server 2016:
For the full list of SQL Server 2016 features, see What's new in SQL Server 2016in the Microsoft documentation. Microsoft SQL Server 2014 featuresIn addition to supported features of SQL Server 2012, Amazon RDS supports the new query optimizer available in SQL Server 2014, and also the delayed durability feature. For a list of unsupported features, see . SQL Server 2014 supports all the parameters from SQL Server 2012 and uses the same default values. SQL Server 2014 includes one new parameter, backup checksum default. For more information, see How to enable the CHECKSUM option if backup utilities do not expose the optionin the Microsoft documentation. Microsoft SQL Server 2012 end of support on Amazon RDSSQL Server 2012 has reached its end of support on Amazon RDS. RDS is upgrading all existing DB instances that are still using SQL Server 2012 to the latest minor version of SQL Server 2014. For more information, see . Microsoft SQL Server 2008 R2 end of support on Amazon RDSSQL Server 2008 R2 has reached its end of support on Amazon RDS. RDS is upgrading all existing DB instances that are still using SQL Server 2008 R2 to the latest minor version of SQL Server 2012. For more information, see . Change data capture support for Microsoft SQL Server DB instancesAmazon RDS supports change data capture (CDC) for your DB instances running Microsoft SQL Server. CDC captures changes that are made to the data in your tables, and stores metadata about each change that you can access later. For more information, see in the Microsoft documentation. Amazon RDS supports CDC for the following SQL Server editions and versions:
To use CDC with your Amazon RDS DB instances, first enable or disable CDC at the database level by using RDS-provided stored procedures. After that, any user that has the You can use CDC and AWS Database Migration Service to enable ongoing replication from SQL Server DB instances. Features not supported and features with limited supportThe following Microsoft SQL Server features aren't supported on Amazon RDS:
The following Microsoft SQL Server features have limited support on Amazon RDS: Multi-AZ deployments using Microsoft SQL Server Database Mirroring or Always On availability groupsAmazon RDS supports Multi-AZ deployments for DB instances running Microsoft SQL Server by using SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs). Multi-AZ deployments provide increased availability, data durability, and fault tolerance for DB instances. In the event of planned database maintenance or unplanned service disruption, Amazon RDS automatically fails over to the up-to-date secondary replica so database operations can resume quickly without manual intervention. The primary and secondary instances use the same endpoint, whose physical network address transitions to the passive secondary replica as part of the failover process. You don't have to reconfigure your application when a failover occurs. Amazon RDS manages failover by actively monitoring your Multi-AZ deployment and initiating a failover when a problem with your primary occurs. Failover doesn't occur unless the standby and primary are fully in sync. Amazon RDS actively maintains your Multi-AZ deployment by automatically repairing unhealthy DB instances and re-establishing synchronous replication. You don't have to manage anything. Amazon RDS handles the primary, the witness, and the standby instance for you. When you set up SQL Server Multi-AZ, RDS configures passive secondary instances for all of the databases on the instance. For more information, see Multi-AZ deployments for Amazon RDS for Microsoft SQL Server. Using Transparent Data Encryption to encrypt data at restAmazon RDS supports Microsoft SQL Server Transparent Data Encryption (TDE), which transparently encrypts stored data. Amazon RDS uses option groups to enable and configure these features. For more information about the TDE option, see Support for Transparent Data Encryption in SQL Server. Functions and stored procedures for Amazon RDS for Microsoft SQL ServerFollowing, you can find a list of the Amazon RDS functions and stored procedures that help automate SQL Server tasks. The time zone of an Amazon RDS DB instance running Microsoft SQL Server is set by default. The current default is Coordinated Universal Time (UTC). You can set the time zone of your DB instance to a local time zone instead, to match the time zone of your applications. You set the time zone when you first create your DB instance. You can create your DB instance by using the AWS Management Console, the Amazon RDS API CreateDBInstance action, or the AWS CLI create-db-instance command. If your DB instance is part of a Multi-AZ deployment (using SQL Server DBM or AGs), then when you fail over, your time zone remains the local time zone that you set. For more information, see . When you request a point-in-time restore, you specify the time to restore to. The time is shown in your local time zone. For more information, see Restoring a DB instance to a specified time. The following are limitations to setting the local time zone on your DB instance:
You can set your local time zone to one of the values listed in the following table. Time zone Standard time offset Description Notes Afghanistan Standard Time (UTC+04:30) Kabul This time zone doesn't observe daylight saving time. Alaskan Standard Time (UTC–09:00) Alaska Aleutian Standard Time (UTC–10:00) Aleutian Islands Altai Standard Time (UTC+07:00) Barnaul, Gorno-Altaysk Arab Standard Time (UTC+03:00) Kuwait, Riyadh This time zone doesn't observe daylight saving time. Arabian Standard Time (UTC+04:00) Abu Dhabi, Muscat Arabic Standard Time (UTC+03:00) Baghdad This time zone doesn't observe daylight saving time. Argentina Standard Time (UTC–03:00) City of Buenos Aires This time zone doesn't observe daylight saving time. Astrakhan Standard Time (UTC+04:00) Astrakhan, Ulyanovsk Atlantic Standard Time (UTC–04:00) Atlantic Time (Canada) AUS Central Standard Time (UTC+09:30) Darwin This time zone doesn't observe daylight saving time. Aus Central W. Standard Time (UTC+08:45) Eucla AUS Eastern Standard Time (UTC+10:00) Canberra, Melbourne, Sydney Azerbaijan Standard Time (UTC+04:00) Baku Azores Standard Time (UTC–01:00) Azores Bahia Standard Time (UTC–03:00) Salvador Bangladesh Standard Time (UTC+06:00) Dhaka This time zone doesn't observe daylight saving time. Belarus Standard Time (UTC+03:00) Minsk This time zone doesn't observe daylight saving time. Bougainville Standard Time (UTC+11:00) Bougainville Island Canada Central Standard Time (UTC–06:00) Saskatchewan This time zone doesn't observe daylight saving time. Cape Verde Standard Time (UTC–01:00) Cabo Verde Is. This time zone doesn't observe daylight saving time. Caucasus Standard Time (UTC+04:00) Yerevan Cen. Australia Standard Time (UTC+09:30) Adelaide Central America Standard Time (UTC–06:00) Central America This time zone doesn't observe daylight saving time. Central Asia Standard Time (UTC+06:00) Astana This time zone doesn't observe daylight saving time. Central Brazilian Standard Time (UTC–04:00) Cuiaba Central Europe Standard Time (UTC+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague Central European Standard Time (UTC+01:00) Sarajevo, Skopje, Warsaw, Zagreb Central Pacific Standard Time (UTC+11:00) Solomon Islands, New Caledonia This time zone doesn't observe daylight saving time. Central Standard Time (UTC–06:00) Central Time (US and Canada) Central Standard Time (Mexico) (UTC–06:00) Guadalajara, Mexico City, Monterrey Chatham Islands Standard Time (UTC+12:45) Chatham Islands China Standard Time (UTC+08:00) Beijing, Chongqing, Hong Kong, Urumqi This time zone doesn't observe daylight saving time. Cuba Standard Time (UTC–05:00) Havana Dateline Standard Time (UTC–12:00) International Date Line West This time zone doesn't observe daylight saving time. E. Africa Standard Time (UTC+03:00) Nairobi This time zone doesn't observe daylight saving time. E. Australia Standard Time (UTC+10:00) Brisbane This time zone doesn't observe daylight saving time. E. Europe Standard Time (UTC+02:00) Chisinau E. South America Standard Time (UTC–03:00) Brasilia Easter Island Standard Time (UTC–06:00) Easter Island Eastern Standard Time (UTC–05:00) Eastern Time (US and Canada) Eastern Standard Time (Mexico) (UTC–05:00) Chetumal Egypt Standard Time (UTC+02:00) Cairo Ekaterinburg Standard Time (UTC+05:00) Ekaterinburg Fiji Standard Time (UTC+12:00) Fiji FLE Standard Time (UTC+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius Georgian Standard Time (UTC+04:00) Tbilisi This time zone doesn't observe daylight saving time. GMT Standard Time (UTC) Dublin, Edinburgh, Lisbon, London This time zone isn't the same as Greenwich Mean Time. This time zone does observe daylight saving time. What version of Windows is Server 2012?Windows Server 2012, codenamed "Windows Server 8", is the sixth version of the Windows Server operating system by Microsoft, as part of the Windows NT family of operating systems.
What type of server is Windows Server?Microsoft Windows Server OS (operating system) is a series of enterprise-class server operating systems designed to share services with multiple users and provide extensive administrative control of data storage, applications and corporate networks.
What is Windows Server 2012 explain its features?Windows Server 2012 includes a number of new features, including Child sessions, RemoteFX Media redirection, and the Remote Desktop Broker client. Windows PowerShell. Windows PowerShell is a task-based command-line shell and scripting language designed especially for system administration.
What are the services of Windows Server 2012?In this article. Active Directory Certificate Services Overview. ... . Active Directory Domain Services Overview. ... . Active Directory Federation Services Overview. ... . Active Directory Lightweight Directory Services Overview. ... . Active Directory Rights Management Services Overview. ... . Application Server Overview. ... . Desktop Experience Overview.. |