连接SQL Server时出现SSDT连接错误

时间:2021-08-25 10:16:58

When I am trying to deploy cube project on SSDT I get the following errors:

当我尝试在SSDT上部署多维数据集项目时,我收到以下错误:

[Severity Code Description Project File Line
Error: The project could not be deployed to the 'CAD_DB_RND2' 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

[严重性代码说明项目文件行错误:由于以下连接问题,无法将项目部署到“CAD_DB_RND2”服务器:无法建立连接。确保服务器正在运行。要验证或更新目标服务器的名称,请在解决方案资源管理器中右键单击项目,选择“项目属性”,单击“部署”选项卡,然后输入服务器的名称。

I provide the correct server name, but I still get the same issue. How can I resolve this error?

我提供了正确的服务器名称,但我仍然遇到同样的问题。我该如何解决这个错误?

1 个解决方案

#1


1  

 First We should go in SQL Server Configuration Manager and check there 
 SQL Server Analysis Server and SQL Server Browser is running or not if it is 
 not running we cant start this services, in my case i did not installed SQL 
 Server Analysis Service I installed and again i started service now it is 
  working for me.

#1


1  

 First We should go in SQL Server Configuration Manager and check there 
 SQL Server Analysis Server and SQL Server Browser is running or not if it is 
 not running we cant start this services, in my case i did not installed SQL 
 Server Analysis Service I installed and again i started service now it is 
  working for me.