当我尝试执行 SQL Server 代理作业(将数据库放在 SSAS 表格上(时,出现以下错误:
[136] Job Test reported: Microsoft.AnalysisServices.Xmla.ConnectionException: A connection cannot be made. Ensure that the server is running. --->
System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:2383
at System.Net.Sockets.TcpClient..ctor(String hostname, Int32 port)
at Microsoft.AnalysisServices.Xmla.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
--- End of inner exception stack trace ---
at Microsoft.AnalysisServices.Xmla.XmlaClient.OpenConnection(ConnectionInfo connectionInfo, Boolean& isSessionTokenNeeded)
at Microsoft.AnalysisServices.Xmla.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.SqlServer.Management.Smo.Olap.SoapClient.Connect()
at OlapEvent(SCH_STEP* pStep, SUBSYSTEM* pSubSystem, SUBSYSTEMPARAMS* pSubSystemParams, Boolean fQueryFlag)
我的问题是:为什么使用 SQL 执行作业时不起作用代理工作并在手动删除相同数据库时工作?什么我应该解决这个问题吗?
对于 SQL Server 代理和 SSAS 之间的连接以工作执行的步骤应将服务器实例称为 \。