Visual Studio 2022-＆GT;尝试安装microsoft.datatools.analysisservices.vsix失败，而用户和服务上的错误

发布于 2025-01-31 05:51:56 字数 6851 浏览 1 评论 0原文

我尝试运行microsoft.datatools.analysisservices.vsix，因为我需要工具来连接到服务器端分析服务，以创建和定义新的OLAP Cube的Star/Snowflake模式。

我刚刚获得了VS2022，这是包装的先决条件，并且安装在错误之前获得了某种方式。

有人经历过吗？

因此，由于安装程序的工作必须已经被列入白名单（我在工作中的客户网站上），而且我不希望使用自己的MS帐户登录，因为该VS2022具有公司许可证。

这是日志中的错误：

microsoft.visualstudio.officedevervepertools.windowsidentityfoundation.msu：当前的OS版本'10 .0.18363.0'不在支持版本中范围'（，6.2）'。 20/05/2022 14:18:40-包装 'sqllocaldb2019，版本= 17.0.62110.20190，chip = x64，语言= en-us' 无法从中下载 'https://download.visualstudio.microsoft.com/download/pr/18a24c82-eca2-4cdf-981e-7713ad6ce07c/c11175b84807c159d627495cf5ac53cd707c8ed7422bf946f30688c11434e5f8/SqlLocalDB.msi'. WebClient下载失败：无法连接到远程服务器。位下载失败：未执行的操作未执行因为用户尚未登录网络。指定的服务不存在。（Hresult的例外：0x800704DD）。 Wininet 下载失败：函数：InternetOpenurl，HR：-2147012867，消息：未知错误12029，签名： PackageID = sqllocaldb2019; packageaction = downloadpackage; returnCode = 0x80131500 20/05/2022 14:18:40-跳过下载包 'ssdt，版本= 17.0.62110.20190，productarch =中性' 或父套件有重大失败。 20/05/2022 14:18:40- 跳过下载包 'ssdt.amd64，版本= 17.0.62110.20190，productarch = x64' 软件包或父套件有重大失败。 20/05/2022 14:18:40- 跳过下载包 '89387616-73C8-4223-A360-F36C90A01F6B，版本= 3.0.3'，因为包装或父套件有重大失败。 20/05/2022 14:20:03-包装 'MSODBCSQL，版本= 17.0.62110.20190，chip = x64，语言= en-us'失败了从 'https://download.visualstudio.microsoft.com/download/pr/81E051B5-3F88-4473-B7F /msodbcsql.msi'。 WebClient下载失败：无法连接到远程服务器。位下载失败：未执行的操作未执行因为用户尚未登录网络。指定的服务不存在。（Hresult的例外：0x800704DD）。 Wininet 下载失败：函数：InternetOpenurl，HR：-2147012867，消息：未知错误12029，签名： PackageID = MSODBCSQL; packageaction = downloadpackage; returnCode = 0x80131500 20/05/2022 14:20:03-跳过安装 'MSODBCSQL，版本= 17.0.62110.20190，chip = x64，语言= en-us'以来下载失败。 20/05/2022 14:20:03-跳过包裹的缓存 'MSODBCSQL，版本= 17.0.62110.20190，chip = x64，语言= en-us' 软件包或父套件有重大失败。 20/05/2022 14:20:03- 跳过包的缓存 'microsoft.visualstudio.component.msodbc.sql，版本= 17.0.31804.368' 由于包装或父套件有重大故障。 20/05/2022 14:20:03-跳过安装 'sqllocaldb2019，版本= 17.0.62110.20190，chip = x64，语言= en-us' 自下载以来，它失败了。 20/05/2022 14:20:03-跳过缓存包裹 'sqllocaldb2019，版本= 17.0.62110.20190，chip = x64，语言= en-us' 由于包装或父套件有重大故障。 20/05/2022 14:20:03-跳过包装的缓存 'microsoft.visualstudio.component.sql.localdb.runtime，版本= 17.0.0.31804.368' 由于包装或父套件有重大故障。 20/05/2022 14:20:03-跳过安装 'ssdt，版本= 17.0.62110.20190，productarch =中性' 或父套件有重大失败。 20/05/2022 14:20:03- 跳过包的缓存 'ssdt，版本= 17.0.62110.20190，productarch =中性' 或父套件有重大失败。 20/05/2022 14:20:03- 跳过安装 'ssdt.amd64，版本= 17.0.62110.20190，productarch = x64' 软件包或父套件有重大失败。 20/05/2022 14:20:03- 跳过包的缓存 'ssdt.amd64，版本= 17.0.62110.20190，productarch = x64' 软件包或父套件有重大失败。 20/05/2022 14:20:03- 跳过包的缓存 'microsoft.visualstudio.component.common.azure.tools，版本= 17.0.0.31804.368' 由于包装或父套件有重大故障。 20/05/2022 14:20:04-跳过包裹的缓存 'mssqlcmdlnutils，版本= 17.0.0.62110.20190，chip = x64，language = en-us' 由于包装或父套件有重大故障。 20/05/2022 14:20:04-跳过包裹的缓存 'microsoft.visualstudio.component.mssql.cmdlnutils，版本= 17.0.0.31804.368' 由于包装或父套件有重大故障。 20/05/2022 14:20:04-跳过包裹的缓存 'microsoft.visualstudio.component.sql.ssdt，版本= 17.0.31804.368' 由于包装或父套件有重大故障。 20/05/2022 14:20:06-跳过安装 '89387616-73C8-4223-A360-F36C90A01F6B，版本= 3.0.3'，因为包装或父套件有重大失败。 20/05/2022 14:20:06- 跳过包的缓存 '89387616-73C8-4223-A360-F36C90A01F6B，版本= 3.0.3'，因为包装或父套件有重大失败。 20/05/2022 14:20:06- 跳过包的缓存 'component.89387616-73C8-4223-A360-F36C90A01F6B，版本= 3.0.3' 软件包或父套件有重大失败。 20/05/2022 14：21：54-安装错误：System.AggregateException：一个或多个发生错误。 ---＆gt; Microsoft.visualstudio.setup.packagefailureexception：软件包 “ msodbcsql”未能下载; package'sqllocaldb2019'未能下载 Microsoft.visualstudio.setup.installoperation.run（cancellationToken token）at Microsoft.visualStudio.Setup.Engine.Runoperation（installoperation installoperation，取消token代币，执行操作，迭代遥测遥测） Microsoft.visualstudio.setup.engine.Runcoreoperation（installoperation 层次，执行动作，迭代操作遥测，取消token代币） Microsoft.visualstudio.setup.engine.install（产品产品，字符串目的地，取消图表） microsoft.visualstudio.extensionmanager.setupengineservice.b__14_0（）在 D：\ a _Work \ 1 \ S \ S \ SRC \ product \ ExtensionManager \ Microsoft.visualStudio.ExtensionEngine \ setupengine \ setupengine \ setupEngineService.cs：line 50 at System.Threading.Tasks.Task1.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- End of inner exception stack trace --- at System.Threading.Tasks.Task. thropifexceptiation（boolean insy.threading.tasks.tasks.task.task.wait（int32 milliseCondStimeout，concellationToken concellationToken）上的thfifexceptional cancellationToken concellationToken）at microsoft.visualstudio.extensial.extension.extension.stensionmanager.setUpengeneService.SetUpEngineService.InstAll（d：\ sr sr sr s \ ______________________________________i extensionManager\Microsoft.VisualStudio.ExtensionEngine\SetupEngine\SetupEngineService.cs:line 50 at Microsoft.VisualStudio.ExtensionManager.InstallModule.PerformSetupEngineInstall(InstallableExtensionImpl extension, Boolean installPerMachine, Boolean isPackComponent, IDictionary2 extensionsInstalledSoFar, List1 extensionsUninstalledSoFar ，iinstalledextensionList motifiedinstalledextensionslist，iprogress 1进度，installflags installflags，异步异步，版本targetsedvsversion， iinstalledextension＆amp; newextension）in D：\ a _Work \ 1 \ S \ S \ SRC \ product \ ExtensionManager \ Microsoft.visualStudio.extensionEngine \ inmp \ enginemodules \ installModule.cs：line 1023 AT microsoft.visualstudio.extensionManager.installModule.installinternal（stransableableExtensionImpl 扩展，installflags installflags，Idictionary 2 extensionsInstalledSofar，list 1 ExtensensionsUninStalledSofar， iinstalledextensionList motifiedinstalledextensionslist，异步异步，Iprogress'1进度，版本 targinalDvSversion）in D：\ a _Work \ 1 \ S \ S \ SRC \ product \ ExtensionManager \ Microsoft.visualStudio.extensionEngine \ inmp \ enginemodules \ installModule.cs：line 265 at Microsoft.visualStudio.extensionManager.installModule.BeginInstall（iinstallableExtension 安装延期，installflags installflags，异步播放异步，版本的targinalDvSversion） D：\ a _Work \ 1 \ S \ S \ SRC \ product \ ExtensionManager \ Microsoft.visualStudio.extensionEngine \ inmp \ enginemodules \ installModule.cs：line 399 at Microsoft.visualstudio.extensionManager.installModule.installworker（iinstallableExtension 扩展，installflags installflags，异步异步） D：\ a _Work \ 1 \ S \ S \ SRC \ product \ ExtensionManager \ Microsoft.visualStudio.extensionEngine \ inmp \ enginemodules \ installModule.cs：line 894 ---＆GT; （内部异常＃0） Microsoft.visualstudio.setup.packagefailureexception：软件包 “ msodbcsql”未能下载; package'sqllocaldb2019'未能下载 Microsoft.visualstudio.setup.installoperation.run（cancellationToken token）at Microsoft.visualStudio.Setup.Engine.Runoperation（installoperation installoperation，取消token代币，执行操作，迭代遥测遥测） Microsoft.visualstudio.setup.engine.Runcoreoperation（installoperation 层次，执行动作，迭代操作遥测，取消token代币） Microsoft.visualstudio.setup.engine.install（产品产品，字符串目的地，取消图表） microsoft.visualstudio.extensionmanager.setupengineservice.b__14_0（）在
中

原文

I tried to run Microsoft.DataTools.AnalysisServices.vsix as I need tools to connect to a server-side Analysis Services in order to create and define a star/snowflake schema for a new OLAP cube.

I have just obtained VS2022, a pre-requisite for the pack, and the install gets some way before stopping with an error.

Has anyone experienced this?

As the installers work therefore URLs must be whitelisted already (I am on client site at work) and i do not wish to login with my own MS account as this VS2022 has a corporate licence.

Here is the error from the log:

Microsoft.VisualStudio.OfficeDeveloperTools.WindowsIdentityFoundation.Msu:
The current OS Version '10.0.18363.0' is not in the supported version
range '(,6.2)'. 20/05/2022 14:18:40 - Package
'sqllocaldb2019,version=17.0.62110.20190,chip=x64,language=en-US'
failed to download from
'https://download.visualstudio.microsoft.com/download/pr/18a24c82-eca2-4cdf-981e-7713ad6ce07c/c11175b84807c159d627495cf5ac53cd707c8ed7422bf946f30688c11434e5f8/SqlLocalDB.msi'.
WebClient download failed: Unable to connect to the remote server.
Bits download failed: The operation being requested was not performed
because the user has not logged on to the network. The specified
service does not exist. (Exception from HRESULT: 0x800704DD). WinInet
download failed: Function: InternetOpenUrl, HR: -2147012867, Message:
Unknown error 12029, Signature:
PackageId=sqllocaldb2019;PackageAction=DownloadPackage;ReturnCode=0x80131500
20/05/2022 14:18:40 - Skipping download of package
'SSDT,version=17.0.62110.20190,productarch=neutral' since the package
or a parent package had a vital failure. 20/05/2022 14:18:40 -
Skipping download of package
'SSDT.amd64,version=17.0.62110.20190,productarch=x64' since the
package or a parent package had a vital failure. 20/05/2022 14:18:40 -
Skipping download of package
'89387616-73c8-4223-a360-f36c90a01f6b,version=3.0.3' since the package
or a parent package had a vital failure. 20/05/2022 14:20:03 - Package
'msodbcsql,version=17.0.62110.20190,chip=x64,language=en-US' failed to
download from
'https://download.visualstudio.microsoft.com/download/pr/81e051b5-3f88-4473-b7f0-a696b9268be5/174a46541461c32552d9b5256628b7e42ef128d1105682e69e75ecadd5cb3708/msodbcsql.msi'.
WebClient download failed: Unable to connect to the remote server.
Bits download failed: The operation being requested was not performed
because the user has not logged on to the network. The specified
service does not exist. (Exception from HRESULT: 0x800704DD). WinInet
download failed: Function: InternetOpenUrl, HR: -2147012867, Message:
Unknown error 12029, Signature:
PackageId=msodbcsql;PackageAction=DownloadPackage;ReturnCode=0x80131500
20/05/2022 14:20:03 - Skipping Install of
'msodbcsql,version=17.0.62110.20190,chip=x64,language=en-US' since
downloading it failed. 20/05/2022 14:20:03 - Skipping cache of package
'msodbcsql,version=17.0.62110.20190,chip=x64,language=en-US' since the
package or a parent package had a vital failure. 20/05/2022 14:20:03 -
Skipping cache of package
'Microsoft.VisualStudio.Component.MSODBC.SQL,version=17.0.31804.368'
since the package or a parent package had a vital failure. 20/05/2022
14:20:03 - Skipping Install of
'sqllocaldb2019,version=17.0.62110.20190,chip=x64,language=en-US'
since downloading it failed. 20/05/2022 14:20:03 - Skipping cache of
package
'sqllocaldb2019,version=17.0.62110.20190,chip=x64,language=en-US'
since the package or a parent package had a vital failure. 20/05/2022
14:20:03 - Skipping cache of package
'Microsoft.VisualStudio.Component.SQL.LocalDB.Runtime,version=17.0.31804.368'
since the package or a parent package had a vital failure. 20/05/2022
14:20:03 - Skipping Install of
'SSDT,version=17.0.62110.20190,productarch=neutral' since the package
or a parent package had a vital failure. 20/05/2022 14:20:03 -
Skipping cache of package
'SSDT,version=17.0.62110.20190,productarch=neutral' since the package
or a parent package had a vital failure. 20/05/2022 14:20:03 -
Skipping Install of
'SSDT.amd64,version=17.0.62110.20190,productarch=x64' since the
package or a parent package had a vital failure. 20/05/2022 14:20:03 -
Skipping cache of package
'SSDT.amd64,version=17.0.62110.20190,productarch=x64' since the
package or a parent package had a vital failure. 20/05/2022 14:20:03 -
Skipping cache of package
'Microsoft.VisualStudio.Component.Common.Azure.Tools,version=17.0.31804.368'
since the package or a parent package had a vital failure. 20/05/2022
14:20:04 - Skipping cache of package
'MsSqlCmdLnUtils,version=17.0.62110.20190,chip=x64,language=en-US'
since the package or a parent package had a vital failure. 20/05/2022
14:20:04 - Skipping cache of package
'Microsoft.VisualStudio.Component.MSSQL.CMDLnUtils,version=17.0.31804.368'
since the package or a parent package had a vital failure. 20/05/2022
14:20:04 - Skipping cache of package
'Microsoft.VisualStudio.Component.SQL.SSDT,version=17.0.31804.368'
since the package or a parent package had a vital failure. 20/05/2022
14:20:06 - Skipping Install of
'89387616-73c8-4223-a360-f36c90a01f6b,version=3.0.3' since the package
or a parent package had a vital failure. 20/05/2022 14:20:06 -
Skipping cache of package
'89387616-73c8-4223-a360-f36c90a01f6b,version=3.0.3' since the package
or a parent package had a vital failure. 20/05/2022 14:20:06 -
Skipping cache of package
'Component.89387616-73c8-4223-a360-f36c90a01f6b,version=3.0.3' since
the package or a parent package had a vital failure. 20/05/2022
14:21:54 - Install Error : System.AggregateException: One or more
errors occurred. --->
Microsoft.VisualStudio.Setup.PackageFailureException: Package
'msodbcsql' failed to download;Package 'sqllocaldb2019' failed to
download at
Microsoft.VisualStudio.Setup.InstallOperation.Run(CancellationToken
token) at
Microsoft.VisualStudio.Setup.Engine.RunOperation(InstallOperation
installOperation, CancellationToken token, ExecuteAction action,
ITelemetryOperation telemetryOperation) at
Microsoft.VisualStudio.Setup.Engine.RunCoreOperation(InstallOperation
coreOperation, ExecuteAction action, ITelemetryOperation
telemetryOperation, CancellationToken token) at
Microsoft.VisualStudio.Setup.Engine.Install(Product product, String
destination, CancellationToken token) at
Microsoft.VisualStudio.ExtensionManager.SetupEngineService.b__14_0()
in
D:\a_work\1\s\src\product\extensionManager\Microsoft.VisualStudio.ExtensionEngine\SetupEngine\SetupEngineService.cs:line
50 at System.Threading.Tasks.Task1.InnerInvoke() at System.Threading.Tasks.Task.Execute() --- End of inner exception stack trace --- at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions) at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken) at Microsoft.VisualStudio.ExtensionManager.SetupEngineService.Install() in D:\a\_work\1\s\src\product\extensionManager\Microsoft.VisualStudio.ExtensionEngine\SetupEngine\SetupEngineService.cs:line 50 at Microsoft.VisualStudio.ExtensionManager.InstallModule.PerformSetupEngineInstall(InstallableExtensionImpl extension, Boolean installPerMachine, Boolean isPackComponent, IDictionary2 extensionsInstalledSoFar, List1 extensionsUninstalledSoFar, IInstalledExtensionList modifiedInstalledExtensionsList, IProgress1 progress, InstallFlags
installFlags, AsyncOperation asyncOp, Version targetedVsVersion,
IInstalledExtension& newExtension) in
D:\a_work\1\s\src\product\extensionManager\Microsoft.VisualStudio.ExtensionEngine\Impl\EngineModules\InstallModule.cs:line
1023 at
Microsoft.VisualStudio.ExtensionManager.InstallModule.InstallInternal(InstallableExtensionImpl
extension, InstallFlags installFlags, IDictionary2 extensionsInstalledSoFar, List1 extensionsUninstalledSoFar,
IInstalledExtensionList modifiedInstalledExtensionsList,
AsyncOperation asyncOp, IProgress`1 progress, Version
targetedVsVersion) in
D:\a_work\1\s\src\product\extensionManager\Microsoft.VisualStudio.ExtensionEngine\Impl\EngineModules\InstallModule.cs:line
265 at
Microsoft.VisualStudio.ExtensionManager.InstallModule.BeginInstall(IInstallableExtension
installableExtension, InstallFlags installFlags, AsyncOperation
asyncOp, Version targetedVsVersion) in
D:\a_work\1\s\src\product\extensionManager\Microsoft.VisualStudio.ExtensionEngine\Impl\EngineModules\InstallModule.cs:line
399 at
Microsoft.VisualStudio.ExtensionManager.InstallModule.InstallWorker(IInstallableExtension
extension, InstallFlags installFlags, AsyncOperation asyncOp) in
D:\a_work\1\s\src\product\extensionManager\Microsoft.VisualStudio.ExtensionEngine\Impl\EngineModules\InstallModule.cs:line
894 ---> (Inner Exception #0)
Microsoft.VisualStudio.Setup.PackageFailureException: Package
'msodbcsql' failed to download;Package 'sqllocaldb2019' failed to
download at
Microsoft.VisualStudio.Setup.InstallOperation.Run(CancellationToken
token) at
Microsoft.VisualStudio.Setup.Engine.RunOperation(InstallOperation
installOperation, CancellationToken token, ExecuteAction action,
ITelemetryOperation telemetryOperation) at
Microsoft.VisualStudio.Setup.Engine.RunCoreOperation(InstallOperation
coreOperation, ExecuteAction action, ITelemetryOperation
telemetryOperation, CancellationToken token) at
Microsoft.VisualStudio.Setup.Engine.Install(Product product, String
destination, CancellationToken token) at
Microsoft.VisualStudio.ExtensionManager.SetupEngineService.b__14_0()
in