官术网_书友最值得收藏!

Choosing the edition

SQL Server is no longer just a database, but has grown into a database platform - an ecosystem -  which consists of many additional services (such as SSRS, SSAS, and SSIS) that supports and also extends the capabilities of modern database usage. When installing Machine Learning R Services (in a database), one should think about the ecosystem environment and which additional services would be used along with R Services. If the business need requires advanced R (or Python) integration and analytics, the Enterprise edition is the right one. If only basic R integration is needed, the standard version will cover the needs. Also, think along the lines of other analytical tools if you need analysis services or reporting services, and which developments tools would also be needed for that (for example, MDX on top of OLAP cubes and running R code against the same data mart).

When you have decided on the version, download the ISO or CAB installation file of SQL Server 2017(or 2016) and start the installation. I will install the Developer edition of SQL Server 2017 (which is, from the installation perspective, almost the same as the 2016 version):

Figure 1: Installation type of SQL Server

Installing a new installation of SQL Server will guarantee that the Machine Learning Services with R (or in-database service) are correctly installed.

In the next step, the installation features must be installed. To have R Services installed, a tick must be placed on R for SQL Server Services (in-database), while for SQL Server 2017, a tick must be placed on R in the Machine Learning Services (in-database) section:

Figure 2: Feature selection for SQL Server

In the following server configuration step, you must check the users and accounts that will have access to services. For R Services (in-database), the SQL Server Launchpad service will be installed and automatically started. This service can be started or stopped after the installation through Windows Application-Services:

Figure 3: Server configuration for SQL Server

After the database engine is configured, you will be prompted to accept the agreement to install Microsoft R Open, making sure that you are aware of the fact that R is under GNU License. By requesting this consent, Microsoft just wants to make sure that the administrator agrees and that all new updates and patches to R Open version will be in accordance with the SQL Server update preferences:

Figure 4: Prompting the content for installing Microsoft R Open

In addition to agreeing to R's agreement, please note that the life cycle of Microsoft R Server is two years. If MRS 8.0 was released in January 2016, the official support ended in January 2018; to be more precise, security and critical updates will come in for a period of one year (until January 2017) and, after that, only the security updates will continue until January 2018. During the year, upgrades will also be received. Please note that it is relevant for the standalone product-Microsoft Machine Learning Server, but it is worth mentioning how long the support timeline will be held.

If you are also installing Python, the same consent will be requested:

Figure 5: Prompting the content to install Python

Once you have selected all of the features, configurations, and consents, you will be presented with an overview of the services and features to be installed:

Figure 6: Selected features ready to be installed

Once the installation is completed, you will have the R Engine for Machine Learning Services and Microsoft Machine Learning Server with R (if selected) installed. Please note that R Engine for R Services (in-database) will have a different R installation, as the standalone Microsoft R Server, and also all the installed packages will be different, under different paths, rights, and security settings.

Figure 7: Completing the installation process
主站蜘蛛池模板: 肥东县| 天峨县| 永年县| 刚察县| 开阳县| 绥化市| 毕节市| 文化| 龙海市| 定安县| 贵阳市| 盈江县| 阳泉市| 青田县| 宁明县| 通海县| 尼勒克县| 高阳县| 万山特区| 门源| 普兰店市| 黄山市| 舒城县| 缙云县| 太仆寺旗| 缙云县| 木兰县| 定南县| 达拉特旗| 安新县| 武鸣县| 汝州市| 五大连池市| 措勤县| 东平县| 富川| 内江市| 兴和县| 鹤庆县| 左权县| 新乡市|