Fix python clustering tutorial and associated docs

Aniruddh25 · Aniruddh25 · commit 0bf50ec0ad6c · 2023-04-11T12:20:45.000-07:00
diff --git a/docs/azure-data-studio/tutorial-backup-restore-sql-server.md b/docs/azure-data-studio/tutorial-backup-restore-sql-server.md
@@ -62,7 +62,7 @@ After you select **Backup**, the **Backup database** dialog box disappears and t
 
 1. Select **Backup file** in the **Restore from** box.
 
-1. Select the ellipses (...) in the **Backup file path** box, and select the latest backup file for *TutorialDB*.
+1. Select the ellipses (...) in the **Backup file path** box, and select the latest backup file for *TutorialDB*. Ensure the SQL Server service has READ permissions on the backup file.
 
 1. Enter **TutorialDB_Restored** in the **Target database** box in the **Destination** section to restore the backup file to a new database. Then select **Restore**.
 
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
@@ -149,8 +149,15 @@ Beginning with [!INCLUDE [sssql22-md](../../includes/sssql22-md.md)], runtimes f
 
     ```cmd
     cd "C:\Program Files\Python310\"
-    python -m pip install dill numpy==1.22.0 pandas patsy python-dateutil
-    python -m pip install https://aka.ms/sqlml/python3.10/windows/revoscalepy-10.0.1-py3-none-any.whl
+    python -m pip install -t "C:\Program Files\Python310\Lib\site-packages" dill numpy==1.22.0 pandas patsy python-dateutil
+    python -m pip install -t "C:\Program Files\Python310\Lib\site-packages" https://aka.ms/sqlml/python3.10/windows/revoscalepy-10.0.1-py3-none-any.whl
+    ```
+
+    Run the following **icacls** commands from a new elevated command prompt to grant **READ & EXECUTE** access to the installed libraries to **SQL Server Launchpad Service** and SID **S-1-15-2-1 (ALL_APPLICATION_PACKAGES)**.
+
+    ```cmd
+    icacls "C:\Program Files\Python310\Lib\site-packages" /grant "NT Service\MSSQLLAUNCHPAD":(OI)(CI)RX /T
+    icacls "C:\Program Files\Python310\Lib\site-packages" /grant *S-1-15-2-1:(OI)(CI)RX /T
     ```
 
 #### Configure Python runtime with SQL Server
diff --git a/docs/machine-learning/tutorials/python-clustering-model-deploy.md b/docs/machine-learning/tutorials/python-clustering-model-deploy.md
@@ -56,6 +56,9 @@ Run the following T-SQL script to create the stored procedure. The procedure rec
 USE [tpcxbb_1gb]
 GO
 
+DROP procedure IF EXISTS [dbo].[py_generate_customer_return_clusters];
+GO
+
 CREATE procedure [dbo].[py_generate_customer_return_clusters]
 AS
 
diff --git a/docs/machine-learning/tutorials/python-clustering-model-prepare-data.md b/docs/machine-learning/tutorials/python-clustering-model-prepare-data.md
@@ -118,7 +118,7 @@ column_info = {
 Results from the query are returned to Python using the Pandas **read_sql** function. As part of the process, you'll use the column information you defined in the previous script.
 
 ```python
-customer_data = pandas.read_sql(input_query, conn_str)
+customer_data = pd.read_sql(input_query, conn_str)
 ```
 
 Now display the beginning of the data frame to verify it looks correct.
diff --git a/docs/machine-learning/tutorials/python-clustering-model.md b/docs/machine-learning/tutorials/python-clustering-model.md
@@ -45,7 +45,10 @@ In [part four](python-clustering-model-deploy.md), learn how to create a stored
 
 ## Prerequisites
 
-::: moniker range=">=sql-server-ver15||>=sql-server-linux-ver15"
+::: moniker range=">=sql-server-ver16||>=sql-server-linux-ver16"
+- [SQL Server Machine Learning Services](../sql-server-machine-learning-services.md) with the Python language option - Follow the installation instructions in the [Windows installation guide](../install/sql-machine-learning-services-windows-install-sql-2022.md) or the [Linux installation guide](../../linux/sql-server-linux-setup-machine-learning-sql-2022.md?toc=%252fsql%252fmachine-learning%252ftoc.json&view=sql-server-linux-ver16&preserve-view=true).
+::: moniker-end
+::: moniker range="=sql-server-ver15||=sql-server-linux-ver15"
 - [SQL Server Machine Learning Services](../sql-server-machine-learning-services.md) with the Python language option - Follow the installation instructions in the [Windows installation guide](../install/sql-machine-learning-services-windows-install.md) or the [Linux installation guide](../../linux/sql-server-linux-setup-machine-learning.md?toc=%252fsql%252fmachine-learning%252ftoc.json&view=sql-server-linux-ver15&preserve-view=true). You can also [enable Machine Learning Services on SQL Server Big Data Clusters](../../big-data-cluster/machine-learning-services.md).
 ::: moniker-end
 ::: moniker range="=sql-server-2017"
@@ -61,7 +64,7 @@ In [part four](python-clustering-model-deploy.md), learn how to create a stored
 
 - Additional Python packages - The examples in this tutorial series use Python packages that you may or may not have installed.
 
-  Open a **Command Prompt** and change to the installation path for the version of Python you use in Azure Data Studio. For example, `cd %LocalAppData%\Programs\Python\Python37-32`. Then run the following commands to install any of these packages that aren't already installed.
+  Open an **Admin Command Prompt** and change to the installation path for the version of Python you use in Azure Data Studio. For example, `cd %LocalAppData%\Programs\Python\Python37-32`. Then run the following commands to install any of these packages that aren't already installed. Ensure these packages are installed in the correct python install location, you can use the option `-t` to specify the destination directory.
 
   ```console
   pip install matplotlib
@@ -71,6 +74,15 @@ In [part four](python-clustering-model-deploy.md), learn how to create a stored
   pip install scikit-learn
   ```
 
+::: moniker range=">=sql-server-ver15"
+  Run the following **icacls** commands to grant **READ & EXECUTE** access to the installed libraries to **SQL Server Launchpad Service** and SID **S-1-15-2-1 (ALL_APPLICATION_PACKAGES)**.
+
+  ```cmd
+    icacls "C:\Program Files\Python310\Lib\site-packages" /grant "NT Service\MSSQLLAUNCHPAD":(OI)(CI)RX /T
+    icacls "C:\Program Files\Python310\Lib\site-packages" /grant *S-1-15-2-1:(OI)(CI)RX /T
+  ```
+::: moniker-end
+
 ## Restore the sample database
 
 The sample dataset used in this tutorial has been saved to a **.bak** database backup file for you to download and use. This dataset is derived from the [tpcx-bb](http://www.tpc.org/tpcx-bb/default5.asp) dataset provided by the [Transaction Processing Performance Council (TPC)](http://www.tpc.org/).
