Deploying SSAS Tabular Project from Server 1 to Server 2

Question

I am developing and environment in my organization. Here is the description of what I want to achieve in the environment setup:

1. It consists of 2 servers (computers).
2. 1st server has a default instance sql server 2022 installed with database engine and analysis service. Following ports are opened: 1433 TCP, 1434 UDP, 2383 TCP. SSMS is also installed on this server.
3. 2nd server has visual studio 2022 installed for developing tabular models.It has analysis service installed (BUT NOT DATABASE ENGINE). SSMS is also installed on this server.
4. When I ping server1 from server2, I get successful results. Also telnet on above 3 ports is working fine.
5. On both of these servers I have made a local user account with same name and password. Then I logged into both of these servers using that account. Its because SSAS uses windows authentication. (Please note that local user is necessary for further development in future, so I must have it and I can not exclude it.)
6. Both these servers run on same LAN.
7. The installed softwares on both servers have same version (2022).

Now, here is what I want to achieve:

1. In server 2 extract data from server 1's database. And then create a tabular model.
2. Deploy back this tabular model onto server 1's analysis service.

I have tried every method I could do:

1. Using visual studio directly.
2. Using deployment wizard.
3. Using cmd.
4. Using json files.(XMLA files not supported.)
5. Using synchronization method.

But none of them worked. I also tried another method: create a backup and restore it onto server 1. But got this error:

TITLE: Microsoft SQL Server Management Studio

The following system error occurred: A device attached to the system is not functioning. The following system error occurred: A device attached to the system is not functioning. The following system error occurred: A device attached to the system is not functioning. (Microsoft.AnalysisServices.Core)

---

BUTTONS:

OK

Any help in this regard is highly appreciated.I am developing and environment in my organization. Here is the description of what I want to achieve in the environment setup:

1. It consists of 2 servers (computers).
2. 1st server has a default instance sql server 2022 installed with database engine and analysis service. Following ports are opened: 1433 TCP, 1434 UDP, 2383 TCP. SSMS is also installed on this server.
3. 2nd server has visual studio 2022 installed for developing tabular models.It has analysis service installed (BUT NOT DATABASE ENGINE). SSMS is also installed on this server.
4. When I ping server1 from server2, I get successful results. Also telnet on above 3 ports is working fine.
5. On both of these servers I have made a local user account with same name and password. Then I logged into both of these servers using that account. Its because SSAS uses windows authentication. (Please note that local user is necessary for further development in future, so I must have it and I can not exclude it.)
6. Both these servers run on same LAN.
7. The installed softwares on both servers have same version (2022).

Now, here is what I want to achieve:

1. In server 2 extract data from server 1's database. And then create a tabular model.
2. Deploy back this tabular model onto server 1's analysis service.

I have tried every method I could do:

1. Using visual studio directly.
2. Using deployment wizard.
3. Using cmd.
4. Using json files.(XMLA files not supported.)
5. Using synchronization method.

But none of them worked. I also tried another method: create a backup and restore it onto server 1. But got this error:

TITLE: Microsoft SQL Server Management Studio

The following system error occurred: A device attached to the system is not functioning. The following system error occurred: A device attached to the system is not functioning. The following system error occurred: A device attached to the system is not functioning. (Microsoft.AnalysisServices.Core)

---

BUTTONS:

OK

Any help in this regard is highly appreciated.