I want to deploy deploy ssas database to server. For this I use powershell and here is this version of the script.

and in powershell I write the following:

D:\deploy.ps1 //ИМЯ сервера в сети//MSSQL2012 D:\1.xmla

Where:

  • deploy.ps1 - script from the blog above,
  • 1.xmla - generated deployment wizard script.

I also tried to write the name of the computer or its IE, the effect is the same. This powershell command responds:

Exception when calling "Connect" with "1" arguments: "A connection cannot be made. Ensure that the server is running."

  • I wanted to answer, but I can not :). The question found its answer: D: \ deploy.ps1 (name or IP of the server) \ MSSQL2012 D: \ Script_deploya.xmla This line will work as it should. The problem was in the arrangements and direction of the slash. Please note that if you have only one Instance MSSQL running on your server, then you do not need to write "\ MSSQL2012". - Skinner2170

0