none
SQL SERVER 2017 R Service - Cannot install packages as it says the library is not writable

    Question

  • Hi All:

    I just have the sql server 2017 installed for testing issue, but then I just find out I cannot install any packages since the library says it is not writable even I have running as an administrator. But when I install the package on personal folders and then copy to the library, it works.. please kindly help with the error message below.

    Msg 39004, Level 16, State 20, Line 39
    A 'R' script error occurred during execution of 'sp_execute_external_script' with HRESULT 0x80004004.
    Msg 39019, Level 16, State 1, Line 39
    An external script error occurred:
    Warning in install.packages("ggplot2", lib = lib.SQL) :
      'lib = "C:\Program Files\Microsoft SQL Server\MSSQL14.VNEXT\R_SERVICES\library"' is not writable
    Error in install.packages("ggplot2", lib = lib.SQL) :
      unable to install packages
    Calls: source -> withVisible -> eval -> eval -> install.packages

    Error in ScaleR.  Check the output for more information.
    Error in eval(expr, envir, enclos) :
      Error in ScaleR.  Check the output for more information.
    Calls: source -> withVisible -> eval -> eval -> .Call
    Execution halted

    Friday, April 28, 2017 11:31 AM

All replies