Visual Studio中创建Analysis Services Cube时连接本地Comms数据库失败的问题排查求助

大家好，我现在碰到个头疼的问题：我正在Visual Studio里开发Analysis Services项目，打算创建Cube，现在需要连接本地的Comms数据库。但在配置好数据源测试连接时，直接失败了，具体报错信息如下：

Test connection failed because of an error in initializing provider.

A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. Client unable to establish connection Registry information is corrupt or missing. Make sure the provider is installed and registered correctly.

我已经做了一些前置排查：我的SQL Server实例已经配置成允许远程连接，同时开启了Windows和SQL Server混合认证模式。但奇怪的是，在SQL Server配置管理器里，SQL Server Native Client下面看不到任何内容。

想请教各位大佬，这个问题到底出在哪？我该怎么操作才能成功连接到Analysis Services呢？

备注：内容来源于stack exchange，提问作者Mohamed Jmal