blocks|key|5762030|text|您需要将多维数据集部署到SSAS实例。请看这里，我有SQL+Server实例和SSAS实例(检查图标以查看区别)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5762031|​|5762032|📷|atomic|offset|length|5762033|5762034|您可以检查是否在服务上运行了它：|5762035|5762036|5762037|5762038|如果没有，可以从sql+server安装光盘进行安装。|5762039|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/5bbd41a4120d69f226dd7c58288345ff.jpeg|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/fc2e836375bb42151caf46e7ba074ec2.jpeg^0|0|0|0|1|0|0|0|0|0|0|1|1|0|0|0^^$0|@$1|2|3|4|5|6|7|11|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|12|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|13|8|@]|9|@$G|14|H|15|1|16]]|A|$]]|$1|I|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|18|8|@]|9|@]|A|$]]|$1|L|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|M|3|E|5|F|7|1A|8|@]|9|@$G|1B|H|1C|1|1D]]|A|$]]|$1|N|3|C|5|6|7|1E|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|1F|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X|Y|-4]]|Z|$5|T|U|V|A|$W|10|Y|-4]]]]

you need to deploy the cube to a SSAS instance. See here I have the SQL Server instance and the SSAS instance (check the icon to see the difference):
<img src="https://i.stack.imgur.com/aDiYp.jpg" alt="enter image description here" />
you can check if you have it running on the services:
<img src="https://i.stack.imgur.com/bpQCR.jpg" alt="enter image description here" />
if you dont have it, yo ucan install from the sql server installation CD

blocks|key|2232932|text|您需要将目标服务器名称更改为远程sql服务器名称或ip。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2232933|在“投标”中，右键单击项目解决方案，然后选择“属性窗口”。您可以在此处指定服务器名称，如下图所示。|2232934|​|2232935|📷|atomic|offset|length|2232936|2232937|希望这能帮上忙。|2232938|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/6f958906596f4a6b9b36aed83501d664.png|imageAlt^0|0|0|0|0|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|Z|8|@]|9|@$I|10|J|11|1|12]]|A|$]]|$1|K|3|E|5|6|7|13|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

You need to change the target Server name as the remote sql server name or ip.

In BIDS right click on your project solution and select properties window. There you can give the server name as given below figure.

<img src="https://i.stack.imgur.com/cAhMf.png" alt="enter image description here">

Hope it helps...

blocks|key|1734336|text|OLAP多维数据集不会部署到SQL+server实例。它们必须部署到Analysis+Services实例。它将在您的服务列表中列为“SQL+Server+Analysis+Services”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1734337|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

OLAP cubes will not deploy to a SQL server instance. They must be deployed to an Analysis Services instance. It will be listed as 'SQL Server Analysis Services' in your service list.

blocks|key|2232999|text|这就是我解决这个问题的方法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2233000|2233001|从MSSQL+Server+Management+Studio复制连接：|ordered-list-item|2233002|2233003|​|2233004|📷|atomic|offset|length|2233005|2233006|2233007|项目>属性>部署>粘贴：|2233008|2233009|2233010|2233011|2233012|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/c200859154c085379aa6e006f314e29e.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/a9427cce84c7e59f115f55587bb86956.png^0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|18|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|1A|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|1B|8|@]|9|@$L|1C|M|1D|1|1E]]|A|$]]|$1|N|3|H|5|6|7|1F|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1G|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1H|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|S|3|H|5|6|7|1J|8|@]|9|@]|A|$]]|$1|T|3|J|5|K|7|1K|8|@]|9|@$L|1L|M|1M|1|1N]]|A|$]]|$1|U|3|H|5|6|7|1O|8|@]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1P|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12|13|-4]]|14|$5|Y|Z|10|A|$11|15|13|-4]]]]

This is what solved it for me:
<ol>
<li>Copy the connection from the MSSQL Server Management Studio:</li>
</ol>
<a href="https://i.stack.imgur.com/pZqS9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pZqS9.png" alt="enter image description here" /></a>
<ol start="2">
<li>Project &gt; Properties &gt; Deployment &gt; Paste:</li>
</ol>
<a href="https://i.stack.imgur.com/ofjRK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ofjRK.png" alt="enter image description here" /></a>

blocks|key|5761948|text|"localhost“是指运行Business+Intelligence+Studio的计算机。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5761949|您说要部署到远程服务器，因此将localhost替换为服务器名称或ip地址(例如"74.125.237.146")|5761950|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

"localhost" refers to the machine you are running the Business Intelligence Studio from. 

You say you want to deploy to a remote server, so replace localhost with the server name or the ip address (e.g. "74.125.237.146")

blocks|key|5762072|text|要根据需要部署多维数据集，您需要一个SQL实例作为源，一个SSAS实例作为目标。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5762073|致以敬意，|5762074|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

to deploy a cube AS you need an SQL instance as source, and an SSAS instance as destination.

regards,

blocks|key|1734431|text|在学习该教程时，我也遇到了同样的错误。我通过以下方式解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1734432|1734433|双击“模拟信息”选项卡中的“项目数据源|unordered-list-item|1734434|”时，我输入了|1734435|用户的凭据，而不是使用服务帐户。|1734436|确保您具有正确的Server\Instance名称，而不是项目部署服务器中的本地主机。|1734437|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|O|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|P|8|@]|9|@]|A|$]]|$1|F|3|G|5|E|7|Q|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|M|$]]

I got the same error while following that tutorial. I solved it by:

<ul>
<li>Double Clicking the Project Data Source</li>
<li>In the Impersonation Information Tab, I entered the credentials for the Windows user instead of using the service account. </li>
</ul>

Make sure you have the proper Server\Instance name instead of local host in the project deployment server.

blocks|key|2232964|text|另一个原因可能是SQL+Server的Express版本。只有标准版本才有Analysis+Service。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2232965|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

One more reason can be Express version of SQL Server. Only standard version has Analysis Service.

blocks|key|2232975|text|在Microsoft+SQL+server中，转到已注册的服务器，然后单击：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2232976|2232977|分析服务图标->打开本地服务器组|blockquote|2232978|2232979|2232980|右键单击服务器的用户名，然后|2232981|2232982|服务控制->启动|2232983|2232984|2232985|它将会工作;)|2232986|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|T|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|U|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|V|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|W|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|X|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|K|3|L|5|E|7|Z|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|-4|5|6|7|13|8|@]|9|@]|A|$]]]|R|$]]

In Microsoft SQL server go to registered servers and click on:

<blockquote>
 Analysis services icon -> open local server groups
</blockquote>

Click right on your username for the server and

<blockquote>
 service control -> start 
</blockquote>

It will work ;)

I'm really new to this, so I am probably making a simple mistake.

I need to make an OLAP cube using a remote database.
After I set up the dimensions and measures and create the cube, I can not get the cube to launch to the local server. 
I keep getting the error,
"The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server."

However, the local SQL server is running(from as far as I can tell), and I have no idea on how to go about fixing this. I've tried replacing "localhost" with "." and the IP, but that hasn't worked either.

Here's the guide I was following:
<a href="http://www.mssqltips.com/sqlservertip/1532/build-a-cube-from-an-existing-data-source-using-sql-server-analysis-services/" rel="noreferrer">http://www.mssqltips.com/sqlservertip/1532/build-a-cube-from-an-existing-data-source-using-sql-server-analysis-services/</a>

Maybe the SQL Server isn't really running? How can I check? 
Or am I skipping over something important when I try to process the cube?

OLAP Cube deployment issues

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云AI代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

功能1上新10个字符

功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符功能2描述100个字符。

功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符功能2上新100个字符。

功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符功能5描述100个字符

功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符功能5上新100个字符

功能4上新

文章&问答评论现已支持表情

全新交互，全新视觉，新增快捷键、悬浮工具栏、高亮块等功能并同时优化现有功能，全面提升创作效率和体验

社区富文本编辑器全新改版！诚邀体验～ 

精选全网热门MCP server，让你的AI更好用 🚀

💥开发者 MCP广场重磅上线！

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我对此真的很陌生，所以我可能犯了一个简单的错误。我需要使用远程数据库创建一个OLAP多维数据集。在我设置了维度和度量并创建了多维数据集之后，我无法将该多维数据集启动到本地服务器。我一直收到这样的错误：“由于以下连接问题，无法将项目部署到'localhost‘服务器:无法建立连接。请确保服务器正在运行。若要验证或更新目标服务器的名称，请在解决方案资源管理器中右键单击项目，选择”项目属性“，单击”部署

问OLAP多维数据集部署问题
EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问OLAP多维数据集部署问题EN

回答 9

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问OLAP多维数据集部署问题
EN