'Couldn't create symbolic link for Extensibility Data

I am trying to set up SQL R Services in an instance of SQL Server Express.

I am getting the error

Unable to launch runtime for 'R' script

and have tried to implement the solution found here.

The following command works successfully in an elevated command prompt:

"X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\R_SERVICES\library\RevoScaleR\rxLibs\x64\RegisterRExt" /uninstall

However, the subsequent command fails:

"X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\R_SERVICES\library\RevoScaleR\rxLibs\x64\RegisterRExt" /install

With the following error message:

> Source directory to pick the RExtension binaries determined to be "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\R_SERVICES\library\RevoScaleR\rxLibs\x64\".  
> Installation flavor was not supplied  
> Connecting to SQL Server...  
> SQL Server binn directory is "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\Binn".  
> Creating user account pool...  
> Working directory from data root "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL" is "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ExtensibilityData".  
> Working Directory Name is "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ExtensibilityData".  
> GetSymbolicLinkPath: Adding ProgramData to symbolic link path  
> Deleting existing symlink:'X:\ProgramData\MSSQLSERVER\Temp-R'.    
> User account pool creation encountered failure. Removing user account pool changes.  
> Deleting user account configuration.  
> Working directory from data root "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL" is "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ExtensibilityData".  
> Working Directory Name is "X:\Program Files\Microsoft SQL Server\MSSQL14.MSSQLSERVER\MSSQL\ExtensibilityData".  
> GetSymbolicLinkPath: Adding ProgramData to symbolic link path  
> Deleting existing symlink:'X:\ProgramData\MSSQLSERVER\Temp-R'.  
>
> Unable to get working directory root for cleanup.
>
> Error: Couldnt create the symbolic link for ExtensibilityData  
> 
> Removing firewall rule for user account pool.  
> Removing user accounts.  
> Processing 020/020  
> Dropped SQL login for the R SQL user group [my user group]  
> 
> Error: Couldnt create the symbolic link for ExtensibilityData  
> Failed to complete the operation successfully.

How do I fix this?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source