正在处理多维数据集-错误-连接到系统的设备不起作用 [英] Processing cube -Error-A device attached to the system is not functioning

问题描述

我试图处理第一个MDX多维数据集。尝试处理多维数据集时出现错误-连接到系统的设备无法正常工作

I trying to process the first MDX cube. I have an error while trying to process the cube- "A device attached to the system is not functioning"

我尝试了以下
a）文件夹am保存我的项目，我对该文件夹拥有完全控制权。
b）在设备管理器上，所有驱动程序都已更新。没有黄色问号。
c）在10-64位窗口上运行。

i have tried the following a) The folder am saving my project i have full control of that folder. b) On Device manager, all drivers are update. No yellow question marks. c) Am on window 10 - 64 bit machine.

请协助

推荐答案

问题与运行SQLServer服务和Analsyis Services服务的帐户的语言环境有关。
您可以使用注册表编辑器更改语言环境，然后重新启动服务器。
使用pstools psgetsid获取您的SQLServer和Analysis Services服务帐户的SID：

The problem is related to the locale of the account running your SQLServer service and Analsyis Services service. You can change the locale using the registry editor, and restart the server. Use pstools psgetsid to get the SID of your the SQLServer and Analysis Services service account:

psgetsid "NT Service\MSSQL$SQL"
psgetsid "NT Service\MSOLAP$SQL"

注册表项Computer\HKEY_USERS\\控制面板\International，并更新Locale和LocaleName。
语言环境= 00000409，LocaleName = zh-CN

Got to registry key Computer\HKEY_USERS\\Control Panel\International and update the Locale and LocaleName. Locale = 00000409 and LocaleName = en-US

重新启动服务器，使此注册表设置更改生效。
处理现在可以正常工作了（您可能必须重新部署SSAS解决方案）。

Restart the server for this registry setting change to become active. Processing will now work (you might have to redeploy the SSAS solution).

这篇关于正在处理多维数据集-错误-连接到系统的设备不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！