Merge pull request #23818 from WilliamDAssafMSFT/202208222-ml-sql-2022

prmerger-automator[bot] · web-flow · commit aeeaa3253192 · 2022-08-23T21:01:32.000Z
20220822 1630 custom install path from monamaki
diff --git a/docs/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022.md b/docs/machine-learning/install/sql-machine-learning-services-windows-install-sql-2022.md
@@ -3,7 +3,7 @@ title: Install SQL Server 2022 Machine Learning Services on Windows
 description: Learn how to install SQL Server 2022 Machine Learning Services on Windows. You can use Machine Learning Services to execute Python, R, or Java scripts in-database.
 ms.prod: sql
 ms.technology: machine-learning-services
-ms.date: 05/24/2022
+ms.date: 08/23/2022
 ms.topic: how-to
 author: WilliamDAssafMSFT
 ms.author: wiassaf
@@ -52,7 +52,7 @@ For local installations, you must run the setup as an administrator. If you inst
 
 If you encounter any installation errors during setup, check the summary log in the Setup Bootstrap log folder. For example, `%ProgramFiles%\Microsoft SQL Server\160\Setup Bootstrap\Log\Summary.txt`.
 
-1. Start the setup wizard for SQL Server.
+1. Start the SQL Setup wizard for SQL Server.
   
 2. On the **Installation** tab, select **New SQL Server stand-alone installation or add features to an existing installation**.
 
@@ -77,6 +77,8 @@ If you encounter any installation errors during setup, check the summary log in
     - [Install Python](#install-python)
     - [Install Java](#install-java)
 
+**Continue to the instructions to [install R](#install-r) or [install Python](#install-python).**
+
 ## Install R
 
 5. Download the most recent version of [R 4.2 for Windows](https://cran.r-project.org/bin/windows/base/) for Windows, and install.
@@ -96,19 +98,17 @@ If you encounter any installation errors during setup, check the summary log in
    - [CompatibilityAPI Windows](https://go.microsoft.com/fwlink/?LinkID=2193827)
    - [RevoScaleR package for Windows](https://go.microsoft.com/fwlink/?LinkID=2193828)
 
-    The following sample scripts can be adapted for the installation:
-    
-    ```r
-    R CMD INSTALL "c:\temp\CompatibilityAPI.zip"
-    R CMD INSTALL "c:\temp\RevoScaleR.zip"
-    ```
+    Assuming you have installed version 4.2.0 of R in its default location, for example `C:\Program Files\R\R-4.2.0`, and downloaded the required packages in `C:\temp` directory, the following sample scripts can be adapted for the installation:
 
-8. Configure the installed R runtime with SQL Server. You can change the default version by using the **RegisterRext.exe** command-line utility. The utility is in an R application folder depending on the installation, usually in one of these two locations: 
+    ```cmd
+    cd C:\Program Files\R\R-4.2.0\bin
+    R.exe CMD INSTALL -l "C:\Program Files\R\R-4.2.0\library" "C:\temp\CompatibilityAPI.zip"
+    R.exe CMD INSTALL -l "C:\Program Files\R\R-4.2.0\library" "C:\temp\RevoScaleR.zip"
+    ```
 
-   - Application installation path: `%ProgramFiles%\R\R-4.2.0\library\RevoScaleR\rxLibs\x64` 
-   - User library path: `%localappdata%\R\win-library\4.2\RevoScaleR\rxLibs\x64`
+8. Configure the installed R runtime with SQL Server. You can change the default version by using the `RegisterRext.exe` command-line utility. The utility is in an R application folder depending on the installation, usually in `%ProgramFiles%\R\R-4.2.0\library\RevoScaleR\rxLibs\x64`.
 
-   The following script can be used to configure the installed R runtime from the installation folder location of **RegisterRext.exe**. The instance name is "MSSQLSERVER" for a default instance of SQL Server, or the instance name for a named instance of SQL Server.
+   The following script can be used to configure the installed R runtime from the installation folder location of `RegisterRext.exe`. The instance name is "MSSQLSERVER" for a default instance of SQL Server, or the instance name for a named instance of SQL Server.
 
   ```cmd
   .\RegisterRext.exe /configure /rhome:"%ProgramFiles%\R\R-4.2.0" /instance:"MSSQLSERVER"
@@ -139,16 +139,26 @@ If you encounter any installation errors during setup, check the summary log in
 
 ## Install Python
 
-5. Download the most recent version of [Python 3.10 for Windows](https://www.python.org/downloads/) for Windows, and install.
+5. Download the most recent version of [Python 3.10 for Windows](https://www.python.org/downloads/) for Windows. Install using the following options:
+    1. Launch the Python Setup application and choose **Customize installation**. 
+    1. Verify the box is checked next to the option to **Install launcher for all users (recommended)**.
+    1. Select all **Optional Features** options, or as desired.
+    1. On the **Advanced Options** page, check **Install for all users**, accept other default options, and select **Install**. It is recommended that the Python installation path is accessible by all users such as `C:\Program Files\Python310 `and it is not specific to a single user.
+
+6. Download the latest version of RevoScalePY package and its dependencies: [revoscalepy Python Windows](https://go.microsoft.com/fwlink/?LinkID=2193924) and install revoscalepy from the Python custom install location. For example: 
 
-6. Install the latest version of RevoScalePY package and its dependencies: [revoscalepy Python Windows](https://go.microsoft.com/fwlink/?LinkID=2193924).
+    ```cmd
+    cd C:\Program Files\Python310\
+    python -m pip install C:\Users\%username%\Downloads\revoscalepy-10.0.0-py3-none-any.whl
+    ```
 
-7. Configure the installed Python runtime with SQL Server. You can change the default version by using the **RegisterRext.exe** command-line utility. The utility is in the user's application library folder, for example:  `C:\Users\<alias>\AppData\Local\Programs\Python\Python310\Lib\site-packages\revoscalepy\rxLibs`.
+7. Configure the installed Python runtime with SQL Server. You can change the default version by using the **RegisterRext.exe** command-line utility. The utility is in the custom install location, for example: `C:\Program Files\Python310\Lib\site-packages\revoscalepy\rxLibs`.
 
     The following script can be used to configure the installed Python runtime from the installation folder location of **RegisterRext.exe**. The instance name is "MSSQLSERVER" for a default instance of SQL Server, or the instance name for a named instance of SQL Server.
     
     ```cmd
-    .\RegisterRext.exe /configure /pythonhome:"C:\Users\<alias>\AppData\Local\Programs\Python\Python310" /instance:"MSSQLSERVER"
+    cd C:\Program Files\Python310\Lib\site-packages\revoscalepy\rxLibs
+    .\RegisterRext.exe /configure /pythonhome:"C:\Program Files\Python310" /instance:"MSSQLSERVER"
     ```
 
 8. Use [SQL Server Management Studio (SSMS)](../../ssms/download-sql-server-management-studio-ssms.md) or [Azure Data Studio](../../azure-data-studio/what-is-azure-data-studio.md) to connect to the instance where you installed SQL Server Machine Learning Services. Select **New Query** to open a query window, and **Execute*** the following command to enable the external scripting feature:
