問題描述
我是 SQL Server 2012 的新手.這是我的情況.
I'm a newbie to SQL Server 2012. Here is my condition.
我有一個正在運(yùn)行的 SQL Server 2012 Business Intelligence SP1.問題是我無法將項目從另一臺計算機(jī)部署到我的 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"服務(wù)器:無法連接到重定向器.確保SQL Browser"服務(wù)正在運(yùn)行.要驗證或更新目標(biāo)服務(wù)器的名稱，請在解決方案資源管理器中右鍵單擊項目，選擇項目屬性，單擊部署選項卡，然后輸入服務(wù)器名稱.
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:
在項目">屬性">部署">目標(biāo)服務(wù)器"上檢查目標(biāo)名稱.
Check the target name on Project > Properties > Deployment > Target server.
檢查服務(wù)器服務(wù) --> 所有 SQL Server 服務(wù)都在運(yùn)行.
Check the server service --> all SQL Server services are running.
該項目可以從服務(wù)器部署.
The project can be deployed from server.
與服務(wù)器的連接正常
我可以從 SQL Server Management Studio 的另一臺計算機(jī)連接到數(shù)據(jù)庫引擎和分析服務(wù).
I can connect to the Database Engine and Analysis Service from another computer from SQL Server Management Studio.
請幫我解決這個問題，這個問題我已經(jīng)搜索了很多天了.
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的遠(yuǎn)程安裝沒有SSAS應(yīng)用的入站防火墻規(guī)則；msmdsrv.exe.
My problem was that the remote installation of SSAS did not have an Inbound firewall rule for SSAS application; msmdsrv.exe.
分辨率:以管理員身份登錄到運(yùn)行 SSAS 的服務(wù)器啟動 Windows 防火墻和高級安全添加入站規(guī)則，給它一個有意義的名字，比如 SQL Server - SSAS行動:允許連接在程序和服務(wù)選項卡上:對于此程序"，請使用瀏覽并識別 msmdsrv.exe對于 SQL Server 2014，這里默認(rèn)是:%ProgramFiles%\Microsoft SQL Server\MSAS12.SQLSVR14\OLAP\bin\msmdsrv.exe(2012年和2016年非常相似，數(shù)字不同)點(diǎn)擊確定；您應(yīng)該會看到一個帶復(fù)選標(biāo)記的綠點(diǎn)再次嘗試您的項目；它應(yīng)該連接，為我做.
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.
注意:如果這也適用于您，請考慮返回入站規(guī)則并考慮出于安全原因添加連接限制.
NOTE: If this also work for you, consider going back to the Inbound Rule and consider adding connection restrictions for security reasons.
這篇關(guān)于SQL Server 2012 SSDT“無法將項目部署到......無法建立連接......"的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！