問題描述
我是 SQL Server 2012 的新手.這是我的情況.
I'm a newbie to SQL Server 2012. Here is my condition.
我有一個正在運行的 SQL Server 2012 Business Intelligence SP1.問題是我無法將項目從另一臺計算機部署到我的 SSAS.
I have a running SQL Server 2012 Business Intelligence SP1. The problem is I cannot deploy a project to my SSAS from another computer.
錯誤是:
由于以下連接問題，項目無法部署到DATABASE-SERVER\MSSQLSERVER"服務器:無法連接到重定向器.確保SQL Browser"服務正在運行.要驗證或更新目標服務器的名稱，請在解決方案資源管理器中右鍵單擊項目，選擇項目屬性，單擊部署選項卡，然后輸入服務器名稱.
The project could not be deployed to the 'DATABASE-SERVER\MSSQLSERVER' server because of the following connectivity problems : A connection cannot be made to redirector. Ensure that 'SQL Browser' service 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.
以下是我嘗試過的事情:
The following is the things that I've tried:
在項目">屬性">部署">目標服務器"上檢查目標名稱.
Check the target name on Project > Properties > Deployment > Target server.
檢查服務器服務 --> 所有 SQL Server 服務都在運行.
Check the server service --> all SQL Server services are running.
該項目可以從服務器部署.
The project can be deployed from server.
與服務器的連接正常
我可以從 SQL Server Management Studio 的另一臺計算機連接到數據庫引擎和分析服務.
I can connect to the Database Engine and Analysis Service from another computer from SQL Server Management Studio.
請幫我解決這個問題，這個問題我已經搜索了很多天了.
Please help me to fix this problem, I've been search for many days for this problem.
謝謝，抱歉我的英語不好.
Thank you, sorry for my bad english.
最好的問候，斯特拉.
推薦答案
我知道這是一個舊線程，但我遇到了同樣的問題，我估計會有更多人遇到這個嗡嗡聲.
I know this is an old thread, but I had the same issue and I reckon more will run into this buzz saw.
我的問題是SSAS的遠程安裝沒有SSAS應用的入站防火墻規則；msmdsrv.exe.
My problem was that the remote installation of SSAS did not have an Inbound firewall rule for SSAS application; msmdsrv.exe.
分辨率:以管理員身份登錄到運行 SSAS 的服務器啟動 Windows 防火墻和高級安全添加入站規則，給它一個有意義的名字，比如 SQL Server - SSAS行動:允許連接在程序和服務選項卡上:對于此程序"，請使用瀏覽并識別 msmdsrv.exe對于 SQL Server 2014，這里默認是:%ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe(2012年和2016年非常相似，數字不同)點擊確定；您應該會看到一個帶復選標記的綠點再次嘗試您的項目；它應該連接，為我做.
Resolution: Log on to the server running SSAS as Administrator Launch Windows Firewall and advanced Security Add Inbound Rule, give it a meaningful name like SQL Server - SSAS Action: Allow the connection On Program and Services Tab: For 'This Program' use Browse and identify msmdsrv.exe For SQL Server 2014, it is by default here: %ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe (Very similar for 2012 and 2016, the numbers are different) Click OK; You should see a green dot with check mark Try your project again; It should connect, did for me.
注意:如果這也適用于您，請考慮返回入站規則并考慮出于安全原因添加連接限制.
NOTE: If this also work for you, consider going back to the Inbound Rule and consider adding connection restrictions for security reasons.
這篇關于SQL Server 2012 SSDT“無法將項目部署到......無法建立連接......"的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！