I am getting the following error on Analysis Services project on Visual Studio 2012 and SQL Server 2014:
The project could not be deployed to the 'MyServerName\InstanceName' server because of the following connectivity problems : Authentication failed. 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.
- On Project-> properties -> Deployment -> Server it has the ServerName\InstanceName properly, using the same ServerName\InstanceName on SSMS I can connect without problem.
- On Data Source I tested the connection and it passed successfully
- Changed the Impersonator user to my user which is Sysadmin
I google it, but all references I found isn't Autentication failure.
Can anyone help me?
EDIT If I execute
telnet ipServer 2382
successfully connects.
I tried with VS2019 and had the same error.
Tried using service account for impersonator, and the user services is administrator on server and sysadmin but also get the same error.
Also I checked this guide and no one of those fixes helps me.