Skip to content

Commit ace2dc8

Browse files
committed
TOC entry bug, 2 articles, ssis-ssrs, 016n
1 parent 8537fd9 commit ace2dc8

14 files changed

Lines changed: 202 additions & 95 deletions

docs/advanced-analytics/install/sql-ml-component-commandline-install.md

Lines changed: 4 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Run SQL Server command line setup to add R language and Python inte
44
ms.prod: sql
55
ms.technology: machine-learning
66

7-
ms.date: 08/21/2018
7+
ms.date: 03/13/2019
88
ms.topic: conceptual
99
author: HeidiSteen
1010
ms.author: heidist
@@ -52,7 +52,7 @@ When installing through the command prompt, [!INCLUDE[ssNoVersion](../../include
5252
| /IACCEPTPYTHONLICENSETERMS | Indicates you have accepted the license terms for using the Python components. |
5353
| /IACCEPTSQLSERVERLICENSETERMS | Indicates you have accepted the license terms for using SQL Server.|
5454
| /MRCACHEDIRECTORY | For offline setup, sets the folder containing the R component CAB files. |
55-
| /MPYCACHEDIRECTORY | For offline setup, sets the folder containing the Python component CAB files. |
55+
| /MPYCACHEDIRECTORY | Reserved for future use. Use %TEMP% to store Python component CAB files for installation on computers that do not have an internet connection. |
5656

5757

5858
## <a name="indb"></a> In-database instance installations
@@ -127,13 +127,13 @@ Setup.exe /qs /ACTION=Install /FEATURES=SQL_INST_MR /INSTANCENAME=MSSQLSERVER
127127

128128
## <a name="silent"></a> Silent install
129129

130-
A silent installation suppresses the check for .cab file locations. For this reason, you must specify the location where .cab files are to be unpacked. You can the temp directory for this.
130+
A silent installation suppresses the check for .cab file locations. For this reason, you must specify the location where .cab files are to be unpacked. For Python, CAB files must be located in %TEMP*. For R, you can set the folder path using You can the temp directory for this.
131131

132132
```cmd
133133
Setup.exe /q /ACTION=Install /FEATURES=SQLEngine,ADVANCEDANALYTICS,SQL_INST_MR,SQL_INST_MPY
134134
/INSTANCENAME=MSSQLSERVER /SQLSYSADMINACCOUNTS="<username>"
135135
/IACCEPTSQLSERVERLICENSETERMS /IACCEPTROPENLICENSETERMS /IACCEPTPYTHONLICENSETERMS
136-
/MRCACHEDIRECTORY=%temp% /MPYCACHEDIRECTORY=%temp%
136+
/MRCACHEDIRECTORY=%temp%
137137
```
138138

139139
## <a name="shared-feature"></a> Standalone server installations

docs/advanced-analytics/install/sql-ml-component-install-without-internet-access.md

Lines changed: 6 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -4,7 +4,7 @@ description: Offline or disconnected Machine Learning R and Python setup on isol
44
ms.prod: sql
55
ms.technology: machine-learning
66

7-
ms.date: 10/01/2018
7+
ms.date: 03/13/2019
88
ms.topic: conceptual
99
author: HeidiSteen
1010
ms.author: heidist
@@ -17,8 +17,8 @@ By default, installers connect to Microsoft download sites to get required and u
1717

1818
In-database analytics consist of database engine instance, plus additional components for R and Python integration, depending on the version of SQL Server.
1919

20-
+ SQL Server 2017 includes R and Python.
21-
+ SQL Server 2016 is R-only.
20+
+ SQL Server 2017 includes R and Python
21+
+ SQL Server 2016 is R-only.
2222

2323
On an isolated server, machine learning and R/Python language-specific features are added through CAB files.
2424

@@ -70,7 +70,9 @@ One way to get an .iso file containing the installation media is through [Visual
7070

7171
## Transfer files
7272

73-
Copy the SQL Server installation media (.iso or .cab) and in-database analytics CAB files to the target computer. Place the CAB files and installation media file in the same folder on the target machine, such as **Downloads** or the setup user's %temp* folder.
73+
Copy the SQL Server installation media (.iso or .cab) and in-database analytics CAB files to the target computer. Place the CAB files and installation media file in the same folder on the target machine, such as the setup user's %TEMP* folder.
74+
75+
The %TEMP% folder is required for Python CAB files. For R, you can use %TEMP% or set the myrcachedirectory parameter to the CAB path.
7476

7577
The following screenshot shows SQL Server 2017 CAB and ISO files. SQL Server 2016 downloads look different: fewer files (no Python), and the installation media file name is for 2016.
7678

58.2 KB
Loading
31.6 KB
Loading
31.4 KB
Loading
56.3 KB
Loading

docs/advanced-analytics/python/setup-python-client-tools-sql.md

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -24,7 +24,7 @@ In this article, learn how to configure a Python development workstation so that
2424
To validate the installation, you can use built-in Jupyter Notebooks as described in this article, or [link the libraries](#install-ide) to PyCharm or any another IDE that you normally use.
2525

2626
> [!Tip]
27-
> For a video demonstration of these exercises, see [Run R and Python remotely in SQL Server from Jupyter Notebooks](https://blogs.msdn.microsoft.com/mlserver/2018/07/10/run-r-and-python-remotely-in-sql-server-from-jupyter-notebooks-or-any-ide/).
27+
> For a video demonstration of these exercises, see [Run R and Python remotely in SQL Server from Jupyter Notebooks](https://youtu.be/D5erljpJDjE).
2828
2929
> [!Note]
3030
> An alternative to client library installation is using a [standalone server](../install/sql-machine-learning-standalone-windows-install.md) as a rich client, which some customers prefer for deeper scenario work. A standalone server is fully decoupled from SQL Server, but because it has the same Python libraries, you can use it as a client for SQL Server in-database analytics. You can also use it for non-SQL-related work, including the ability to import and model data from other data platforms. If you install a standalone server, you can find the Python executable at this location: `C:\Program Files\Microsoft SQL Server\140\PYTHON_SERVER`. To validate your installation, [open a Jupyter notebook](#python-tools) to run commands using the Python.exe at that location.

0 commit comments

Comments
 (0)