rxPredict抛出SQL Server不存在或访问被拒绝错误

问题描述

大家好，

我正在尝试MSDN上的SQL Server R服务教程 - 链接如下：

https：/ /msdn.microsoft.com/en-us/library/mt629164.aspx

当我运行rxPredict命令时：

rxPredict（modelObject = logitObj ，data = featureDataSource，outData = scoredOutput，  


          predVarNames =" Score"，类型= QUOT;响应"，  


          writeModelVars = TRUE，覆盖= TRUE）&NBSP ;

我收到以下错误：

 ====== SG01NB-4300092（进程1）已开始运行2016-07-04 09：43：35.00 ====== 
 
 [Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] SQL Server不存在或访问被拒绝。 
文件中的捕获异常：CxAnalysis.cpp，行：5682。ThreadID：13560 Rethrowing。 
文件中的捕获异常：CxAnalysis.cpp，行：5249。ThreadID：13560 Rethrowing。 
 
 [微软] [ODBC驱动程序管理器]未打开连接
 
 ODBC错误在调用SQLDisconnect 
错误doTryCatch（回报（表达式），姓名，parentenv，处理程序） ：
 [Microsoft] [ODBC SQL Server驱动程序] [DBNETLIB] SQL Server不存在或访问被拒绝。 
来电：来源... tryCatch  - > tryCatchList  - > tryCatchOne  - > doTryCatch  - > .Call 
执行暂停
  rxCompleteClusterJob中的错误（hpcServerJob，consoleOutput，autoCleanup）：
无可用结果 - 最终作业state：failed  

我确保我的rxSetComputeContext（cc）使用的是有效的用户登录信息创建表格。我也在我正在处理的本地计算机上安装SQL Server，因此它不会成为网络问题。

是否有人遇到此问题并设法成功运行此语句？

感谢您的回复和帮助！

Ian

解决方案

Hi everyone,

I am trying out the SQL Server R services tutorial on MSDN - link below:

https://msdn.microsoft.com/en-us/library/mt629164.aspx

When I run the rxPredict command:

rxPredict(modelObject = logitObj, data = featureDataSource, outData = scoredOutput,  
          predVarNames = "Score", type = "response",  
          writeModelVars = TRUE, overwrite = TRUE) 

I get the following error:

======  SG01NB-4300092  ( process  1 ) has started run at  2016-07-04 09:43:35.00  ======

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Caught exception in file: CxAnalysis.cpp, line: 5682. ThreadID: 13560 Rethrowing.
Caught exception in file: CxAnalysis.cpp, line: 5249. ThreadID: 13560 Rethrowing.

[Microsoft][ODBC Driver Manager] Connection not open

ODBC Error in SQLDisconnect
Error in doTryCatch(return(expr), name, parentenv, handler) :
  [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Calls: source ... tryCatch -> tryCatchList -> tryCatchOne -> doTryCatch -> .Call
Execution halted
Error in rxCompleteClusterJob(hpcServerJob, consoleOutput, autoCleanup) :
  No results available - final job state: failed

I have made sure that my rxSetComputeContext(cc) is using a valid user login that can create tables. I am also installing SQL Server on the local machine I am working on so it cannot be a network issue.

Has anyone encountered this issue and manage to run this statement successfully?

Thanks for any replies and help!

Ian

解决方案

这篇关于rxPredict抛出SQL Server不存在或访问被拒绝错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！