SSAS Tabular Error Fixed: Cannot Deploy Metadata. Reason: An error Occurred While Connecting to Server
If you are developing SSAS Tabular models using Visual Studio 2017 and SQL Server 2017, perhaps there is a chance you to get the error "cannot deploy metadata. Reason: An error occurred while connecting to server" when you are trying to deploy your model into SSAS Tabular server. Error Message: Solution: Go to Project Properties and make sure you've given full server name like DEVSVR\SSAS17 instead localhost\SSAS17. 1. Go to Solution Explorer and Right click the Project and Goto Properties. 2. Verify the Deployment Server Name. Ideally, the issue must be fixed by performing above step. There are some other steps I found on the internet like upgrading to the Latest version of SSDT. You can try out that as well in case of this didn't work.