Установка служб integration services (ssis)install integration services (ssis)

SQL Server Editions

The following table describes the editions of SQL Server.


SQL Server edition Definition
Enterprise The premium offering, SQL Server Enterprise edition delivers comprehensive high-end datacenter capabilities with blazing-fast performance, unlimited virtualization, and end-to-end business intelligence — enabling high service levels for mission-critical workloads and end-user access to data insights.
Standard SQL Server Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premise and cloud — enabling effective database management with minimal IT resources.
Web SQL Server Web edition is a low total-cost-of-ownership option for Web hosters and Web VAPs to provide scalability, affordability, and manageability capabilities for small to large-scale Web properties.
Developer SQL Server Developer edition lets developers build any kind of application on top of SQL Server. It includes all the functionality of Enterprise edition, but is licensed for use as a development and test system, not as a production server. SQL Server Developer is an ideal choice for people who build SQL Server and test applications.
Express editions Express edition is the entry-level, free database and is ideal for learning and building desktop and small server data-driven applications. It is the best choice for independent software vendors, developers, and hobbyists building client applications. If you need more advanced database features, SQL Server Express can be seamlessly upgraded to other higher end versions of SQL Server. SQL Server Express LocalDB, a lightweight version of Express that has all of its programmability features, yet runs in user mode, and has a fast, zero-configuration installation and a short list of prerequisites.

Запуск программы установкиRun setup

Для локальных установок необходимо запускать программу установки с правами администратора.For local installations, you must run Setup as an administrator. При установке SQL ServerSQL Server из удаленной общей папки необходимо использовать учетную запись домена с разрешениями на чтение и выполнение для удаленной общей папки.If you install SQL ServerSQL Server from a remote share, you must use a domain account that has read and execute permissions on the remote share.

Запустите мастер установки SQL Server 2016.Start the setup wizard for SQL Server 2016.

На вкладке Установка выберите параметр Новая установка изолированного экземпляра SQL Server или добавление компонентов к существующей установке.On the Installation tab, select New SQL Server stand-alone installation or add features to an existing installation.

Выберите следующие компоненты на странице Выбор компонентов:On the Feature Selection page, select the following options:

Выберите Службы ядра СУБД.Select Database Engine Services. Ядро СУБД требуется в каждом экземпляре, использующем машинное обучение.The database engine is required in each instance that uses machine learning.

Выберите Службы R (в базе данных) .Select R Services (In-Database)

Устанавливает поддержку использования языка R в базе данных.Installs support for in-database use of R.

Важно! Не устанавливайте R Server и R Services одновременно.Do not install R Server and R Services at the same time.

На странице Согласие на установку Microsoft R Open нажмите кнопку Принять.On the Consent to Install Microsoft R Open page, click Accept. Принятие лицензионного соглашения требуется для скачивания Microsoft R Open — дистрибутива, содержащего базовые пакеты и средства R с открытым исходным кодом, а также поставщики услуг подключения и расширенные пакеты R от команды разработки Microsoft R.This license agreement is required to download Microsoft R Open, which includes a distribution of the open-source R base packages and tools, together with enhanced R packages and connectivity providers from the Microsoft R development team.

После принятия лицензионного соглашения в процессе подготовки программы установки возникает небольшая пауза.After you have accepted the license agreement, there is a brief pause while the installer is prepared. Нажмите кнопку Далее, когда она станет доступной.Click Next when the button becomes available.

На странице Все готово для установки проверьте, включены ли указанные ниже компоненты, и нажмите Установить.On the Ready to Install page, verify that the following items are included, and then select Install.

Службы ядра СУБДDatabase Engine Services

Службы R (в базе данных)R Services (In-Database)

Если после завершения установки будет предложено перезагрузить компьютер, выполните перезагрузку.After setup is complete, if you are instructed to restart the computer, do so now

После завершения установки важно прочитать сообщение мастера установки.It is important to read the message from the Installation Wizard when you have finished with Setup. Дополнительные сведения см. в разделе View and Read SQL Server Setup Log Files.For more information, see View and Read SQL Server Setup Log Files.

Получение установочного носителяGet the installation media

Место, откуда можно скачать SQL ServerSQL Server, зависит от выпуска.The download location for SQL ServerSQL Server depends on the edition:

  • Выпуски Enterprise, Standard и Express SQL Server предназначены для использования в рабочей среде.SQL Server Enterprise, Standard, and Express Editions are licensed for production use. Чтобы получить установочный носитель с выпуском Enterprise или Standard, обратитесь к своему поставщику программного обеспечения.For the Enterprise and Standard Editions, contact your software vendor for the installation media. Сведения о приобретении и каталог партнеров Майкрософт можно найти на веб-сайте приобретения продуктов Майкрософт.You can find purchasing information and a directory of Microsoft partners on the Microsoft purchasing website.
  • Последняя версия бесплатного выпуска.The latest free edition.

Требование для установки исправленияInstall patch requirement


Корпорация Майкрософт выявила проблему с определенной версией двоичных файлов среды выполнения Microsoft VC++ 2013, которые SQL Server устанавливает в качестве необходимого компонента.Microsoft has identified a problem with the specific version of Microsoft VC++ 2013 Runtime binaries that are installed as a prerequisite by SQL Server. Если это обновление двоичных файлов среды выполнения VC не установлено, в SQL Server могут возникать проблемы с надежностью в определенных сценариях.If this update to the VC runtime binaries is not installed, SQL Server may experience stability issues in certain scenarios. Перед установкой SQL Server выполните инструкции, приведенные в , чтобы узнать, требуется ли на вашем компьютере исправление для двоичных файлов среды выполнения VC.Before you install SQL Server follow the instructions at to see if your computer requires a patch for the VC runtime binaries.

Редакции MS SQL Server 2019

Всего есть 5 выпусков (редакций) MSSQL 2019:

  • Express является бесплатной для использования редакцией. Функционал довольно ограничен, самое ощутимое ограничение экспресс версии — максимальный размер базы 10 ГБ. Эта редакция подойдет для небольших проектов, например, студенческих работ или для обучения SQL/T-SQL.
  • Standard это полноценная платная редакция, но многих функций всё еще нет. Максимальный объём оперативной памяти, который сможет использовать SQL Server – 128 ГБ, также отсутствуют группы доступности AlwaysOn и другие компоненты. Standard предназначен для приложений в небольших организациях.
  • Enterprise включает в себя все возможные функции и компоненты, никаких ограничений нет. Корпоративная редакция обычно используется крупными корпорациями или компаниями, которым необходим функционал этой версии.
  • Developer редакция так же как и Enterprise не имеет никаких ограничений и её можно использовать бесплатно, но она может использоваться только для разработки и тестирования приложений.
  • Web редакция почти ничем не отличается от standard, кроме как более сильными ограничениями в функционале и соответственно более низкой стоимости лицензирования.

도움말 보기

  • UserVoice: SQL Server 개선을 위한 제안이 있나요?UserVoice: Have suggestions for improving SQL Server?
  • 설정 및 업그레이드: MSDN 포럼Set up and upgrade: MSDN Forums
  • SQL Server Data Tools: MSDN 포럼SQL Server Data Tools: MSDN Forums
  • Transact-sql: MSDN 포럼Transact-SQL: MSDN Forums
  • SQL Server 보안: MSDN 포럼SQL Server Security: MSDN Forums
  • DBA 스택 교환 (sql server 태그): 질문 SQL ServerDBA Stack Exchange (tag sql-server): Ask SQL Server questions
  • Stack Overflow (sql server 태그): SQL 개발 질문에 대 한 답변Stack Overflow (tag sql-server): Answers to SQL development questions
  • Reddit: SQL Server에 대 한 일반 토론Reddit: General discussion about SQL Server
  • Microsoft SQL Server 사용 조건 및 정보Microsoft SQL Server License Terms and Information
  • 비즈니스 사용자에 대한 지원 옵션Support options for business users
  • Microsoft에 문의Contact Microsoft
  • 그 밖의 SQL Server 도움말 및 피드백Additional SQL Server help and feedback

RDBMS Manageability

Feature Enterprise Standard Web Express with Advanced Services Express
User instances No No No Yes Yes
LocalDB No No No Yes No
Dedicated admin connection Yes Yes Yes Yes with trace flag Yes with trace flag
PowerShell scripting support Yes Yes Yes Yes Yes
SysPrep support 1 Yes Yes Yes Yes Yes
Support for data-tier application component operations — extract, deploy, upgrade, delete Yes Yes Yes Yes Yes
Policy automation (check on schedule and change) Yes Yes Yes No No
Performance data collector Yes Yes Yes No No
Able to enroll as a managed instance in multi-instance management Yes Yes Yes No No
Standard performance reports Yes Yes Yes No No
Plan guides and plan freezing for plan guides Yes Yes Yes No No
Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes Yes
Automatic indexed views maintenance Yes Yes Yes No No
Distributed partitioned views Yes No No No No
Parallel indexed operations Yes No No No No
Automatic use of indexed view by query optimizer Yes No No No No
Parallel consistency check Yes No No No No
SQL Server Utility Control Point Yes No No No No
Buffer pool extension Yes Yes No No No

1 For more information, see Considerations for Installing SQL Server Using SysPrep.

2 Applies to SQL Server 2016 (13.x) SP1 as part of creating a common programmability surface area (CPSA) across editions.

Службы SQL Server 2017 Analysis Services (SSAS)SQL Server 2017 Analysis Services (SSAS)

SQL Server Analysis Services 2017 включает множество улучшений для табличных моделей.SQL Server Analysis Services 2017 introduces many enhancements for tabular models. К ним относятся следующие объекты.These include:

  • Табличный режим стал параметром установки по умолчанию для Analysis Services.Tabular mode as the default installation option for Analysis Services. (CTP 2.0)(CTP 2.0)
  • Безопасность на уровне объектов для защиты метаданных табличных моделей.Object-level security to secure the metadata of tabular models. (CTP 2.0)(CTP 2.0)
  • Возможность легко создавать связи на основе полей дат.Date relationships to easily create relationships based on date fields. (CTP 2.0)(CTP 2.0)
  • Новые источники получения данных (Power Query) и поддержка существующих источников данных DirectQuery для запросов на языке M.New Get Data (Power Query) data sources, and existing DirectQuery data sources support for M queries. (CTP 2.0)(CTP 2.0)
  • Редактор DAX для SSDT.DAX Editor for SSDT. (CTP 2.0)(CTP 2.0)
  • Подсказки по кодированию — продвинутая функция для оптимизации обновления данных больших табличных моделей в памяти.Encoding hints, an advanced feature for optimizing data refresh of large in-memory tabular models. (CTP 1.3)(CTP 1.3)
  • Поддержка уровня совместимости 1400 для табличных моделей.Support for the 1400 Compatibility level for tabular models. Чтобы создать новый проект табличной модели с уровнем совместимости 1400 или перевести уже существующий проект на этот уровень, загрузите и установите SQL Server Data Tools (SSDT) 17.0 RC2.To create new or upgrade existing tabular model projects to the 1400 compatibility level, download and install SQL Server Data Tools (SSDT) 17.0 RC2. (CTP 1.1)(CTP 1.1)
  • Современный интерфейс получения данных для табличных моделей с уровнем совместимости 1400.A modern Get Data experience for tabular models at the 1400 compatibility level. См. блог команды разработчиков Analysis Services.See the Analysis Services Team Blog. (CTP 1.1)(CTP 1.1)
  • Свойство Скрыть члены скрывает пустые элементы в неоднородных иерархиях.Hide Members property to hide blank members in ragged hierarchies. (CTP 1.1)(CTP 1.1)
  • Новое действие Строки детализации для конечного пользователя, позволяющее Показать подробности по статистических данным.New Detail Rows end-user action to Show Details for aggregated information. Функции SELECTCOLUMNS и DETAILROWS для создания выражений со строками детализации.SELECTCOLUMNS and DETAILROWS functions for creating Detail Rows expressions. (CTP 1.1)(CTP 1.1)
  • DAX-оператор IN для указания множества значений.DAX IN operator for specifying multiple values. (CTP 1.1)(CTP 1.1)

Дополнительные сведения см. в статье What’s New in SQL Server Analysis Services (Новые возможности SQL Server Analysis Services).For more information, see What’s new in SQL Server Analysis Services.

하드웨어 요구 사항Hardware requirements


SQL Server 2016 및 SQL Server 2017에는 다음과 같은 하드웨어 요구 사항이 적용됩니다.The following hardware requirements apply to SQL Server 2016 and SQL Server 2017:

구성 요소Component 요구 사항Requirement
하드 디스크Hard Disk SQL ServerSQL Server 에는 최소 6GB의 사용 가능한 하드 디스크 공간이 필요합니다.requires a minimum of 6 GB of available hard-disk space.디스크 공간 요구 사항은 설치하는 SQL ServerSQL Server 구성 요소에 따라 다릅니다.Disk space requirements will vary with the SQL ServerSQL Server components you install. 자세한 내용은 이 문서의 뒷부분에 있는 을 참조하세요.For more information, see later in this article. 데이터 파일에 대해 지원되는 스토리지 유형에 대한 자세한 내용은 을 참조하십시오.For information on supported storage types for data files, see . SQL Server는 NTFS 또는 ReFS 파일 형식의 컴퓨터에 설치하는 것이 권장됩니다.Installing SQL Server on computers with the NTFS or ReFS file formats is recommended. FAT32 파일 시스템도 지원되긴 하나 NTFS 또는 ReFS 파일 시스템보다 안전하지 않으므로 권장하지는 않습니다.The FAT32 file system is supported but not recommended as it is less secure than the NTFS or ReFS file systems. 설치 중에는 읽기 전용 드라이브, 매핑된 드라이브 또는 압축 드라이브가 차단됩니다.Read-only, mapped, or compressed drives are blocked during installation.
드라이브Drive 디스크에서 설치하려면 경우에 따라 DVD 드라이브가 필요합니다.A DVD drive, as appropriate, is required for installation from disc.
모니터Monitor SQL ServerSQL Server 에는 Super-VGA(800×600) 이상 해상도의 모니터가 필요합니다.requires Super-VGA (800×600) or higher resolution monitor.
인터넷Internet 인터넷 기능을 사용하려면 인터넷에 액세스해야 합니다(요금이 부과될 수 있음).Internet functionality requires Internet access (fees may apply).
메모리*Memory * 최소:Minimum:Express Edition: 512MBExpress Editions: 512 MB기타 모든 버전: 1 GBAll other editions: 1 GB권장:Recommended:Express Edition: 1 GBExpress Editions: 1 GB기타 모든 버전: 최소 4GB가 필요하며 데이터베이스 크기가 늘어남에 따라 메모리 크기를 늘려 성능을 최대화해야 합니다.All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
프로세서 속도Processor Speed 최소: x64 프로세서: 1.4GHzMinimum: x64 Processor: 1.4 GHz권장: 2.0GHz 이상Recommended: 2.0 GHz or faster
프로세서 유형Processor Type x64 프로세서: AMD Opteron, AMD Athlon 64, Intel EM64T를 지원하는 Intel Xeon, Intel EM64T를 지원하는 Intel Pentium IVx64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

참고

SQL ServerSQL Server 설치는 x64 프로세서에서만 지원됩니다.Installation of SQL ServerSQL Server is supported on x64 processors only. x86 프로세서에서는 더 이상 지원되지 않습니다.It is no longer supported on x86 processors.

*데이터베이스 엔진 서비스Data Quality Services(DQS)에 Data Quality 서버Data Quality Server 구성 요소를 설치하는 데 필요한 최소 메모리는 SQL ServerSQL Server 최소 메모리 요구 사항과 달리 2GB RAM입니다.* The minimum memory required for installing the Data Quality 서버Data Quality Server component in 데이터베이스 엔진 서비스Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL ServerSQL Server minimum memory requirement. DQS 설치에 대한 자세한 내용은 Install Data Quality Services를 참조하십시오.For information about installing DQS, see Install Data Quality Services.

Deciding Among SQL Server Components

Use the Feature Selection page of the SQL Server Installation Wizard to select the components to include in an installation of SQL Server. By default, none of the features in the tree are selected.

Use the information in the following tables to determine the set of features that best fits your needs.

Server components Description
SQL Server Database Engine SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, in database analytics integration, and PolyBase integration for access to Hadoop and other heterogeneous data sources, and the Data Quality Services (DQS) server.
Analysis Services Analysis Services includes the tools for creating and managing online analytical processing (OLAP) and data mining applications.
Reporting Services Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications.
Integration Services Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data. It also includes the Data Quality Services (DQS) component for Integration Services.
Master Data Services Master Data Services (MDS) is the SQL Server solution for master data management. MDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an Add-in for Excel that can be used to manage data.
R Services (In-Database) R Services (In-Database) supports distributed, scalable R solutions on multiple platforms and using multiple enterprise data sources, including Linux, Hadoop, and Teradata.
Management tools Description
SQL Server Management Studio SQL Server Management Studio is an integrated environment to access, configure, manage, administer, and develop components of SQL Server. Management Studio lets developers and administrators of all skill levels use SQL Server. Download and install Management Studio from Download SQL Server Management Studio
SQL Server Configuration Manager SQL Server Configuration Manager provides basic configuration management for SQL Server services, server protocols, client protocols, and client aliases.
SQL Server Profiler SQL Server Profiler provides a graphical user interface to monitor an instance of the Database Engine or Analysis Services.
Database Engine Tuning Advisor Database Engine Tuning Advisor helps create optimal sets of indexes, indexed views, and partitions.
Data Quality Client Provides a highly simple and intuitive graphical user interface to connect to the DQS server, and perform data cleansing operations. It also allows you to centrally monitor various activities performed during the data cleansing operation.
SQL Server Data Tools SQL Server Data Tools provides an IDE for building solutions for the Business Intelligence components: Analysis Services, Reporting Services, and Integration Services. (Formerly called Business Intelligence Development Studio). SQL Server Data Tools also includes «Database Projects», which provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the enhanced Server Explorer in Visual Studio to easily create or edit database objects and data, or execute queries.
Connectivity Components Installs components for communication between clients and servers, and network libraries for DB-Library, ODBC, and OLE DB.
Documentation Description
SQL Server Books Online Core documentation for SQL Server.

Developer and Evaluation Editions For features supported by Developer and Evaluation editions, see features listed for the SQL Server Enterprise Edition in the tables below.


The Developer edition continues to support only 1 client for SQL Server Distributed Replay.

Hardware requirements

The following hardware requirements apply to SQL Server 2016 and SQL Server 2017:

Component Requirement
Hard Disk SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. For more information, see later in this article. For information on supported storage types for data files, see . Installing SQL Server on computers with the NTFS or ReFS file formats is recommended. The FAT32 file system is supported but not recommended as it is less secure than the NTFS or ReFS file systems. Read-only, mapped, or compressed drives are blocked during installation.
Drive A DVD drive, as appropriate, is required for installation from disc.
Monitor SQL Server requires Super-VGA (800×600) or higher resolution monitor.
Internet Internet functionality requires Internet access (fees may apply).
Memory * Minimum: Express Editions: 512 MB All other editions: 1 GBRecommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor Speed Minimum: x64 Processor: 1.4 GHzRecommended: 2.0 GHz or faster
Processor Type x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

Note

Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.

* The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement. For information about installing DQS, see Install Data Quality Services.

Пакеты RR packages

В дополнение к корпоративным пакетам Майкрософт можно использовать платформы и пакеты с открытым кодом.You can use open-source packages and frameworks, in addition to Microsoft’s enterprise packages. Наиболее распространенные пакеты R с открытым кодом предварительно установлены в R Services.Most common open-source R packages are pre-installed in R Services. Также включены следующие пакеты R от Майкрософт:The following R packages from Microsoft are also included:

ПакетPackage ОписаниеDescription
RevoScaleRRevoScaleR Основной пакет для масштабируемого R. Преобразования и обработка данных, статистическая сводка, визуализация и многие виды моделирования.The primary package for scalable R. Data transformations and manipulation, statistical summarization, visualization, and many forms of modeling. Кроме того, функции в этом пакете автоматически распределяют рабочие нагрузки между доступными ядрами для параллельной обработки.Additionally, functions in this package automatically distribute workloads across available cores for parallel processing.
MicrosoftML (R)MicrosoftML (R) Добавляет алгоритмы машинного обучения для создания пользовательских моделей для анализа текста, анализа изображений и анализа тональности.Adds machine learning algorithms to create custom models for text analysis, image analysis, and sentiment analysis.
olapRolapR Функции R, используемые для запросов многомерных выражений к кубу OLAP SQL Server Analysis Services.R functions used for MDX queries against a SQL Server Analysis Services OLAP cube.
sqlrutilssqlrutils Механизм для использования скриптов R в хранимой процедуре T-SQL, регистрации этой хранимой процедуры в базе данных и ее запуска из среды разработки R.A mechanism to use R scripts in a T-SQL stored procedure, register that stored procedure with a database, and run the stored procedure from an R development environment.
Microsoft R OpenMicrosoft R Open Microsoft R Open (MRO) — это улучшенная версия R от Майкрософт.Microsoft R Open (MRO) is the enhanced distribution of R from Microsoft. Это полная платформа с открытым кодом для статистического анализа и обработки и анализа данных.It is a complete open-source platform for statistical analysis and data science. Она основана на R, полностью совместима с ним и включает дополнительные возможности для повышения производительности и воспроизводимости.It is based on and 100% compatible with R, and includes additional capabilities for improved performance and reproducibility.

С этим читают