Security issue SSAS (connecting remotely via SSMS)

• Peter Gadsby

  SSCrazy

  Points: 2718

  More actions

  February 25, 2009 at 7:38 am

  #197457

  Hi,

  I'm new to SSAS.... I am trying to remotely connect to SSRS via SSMS.

  I have changed my windows login to be an administrator on the server. I have also added the windows user to SSAS on the machine.

  I'm also getting an error when I try and connect to a cube stored in SSAS in Excel. The error is .... An error was encountered in the transport layer

  Any thoughts very much appreciated.

  Thanks

  I get the following error:-

  ===================================

  Cannot connect to

  ===================================

  Authentication failed. (Microsoft.AnalysisServices.AdomdClient)

  ------------------------------

  Program Location:

  at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime)

  at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)

  at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)

  at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()

  at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)

  at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

  ===================================

  The logon attempt failed (Microsoft.AnalysisServices.AdomdClient)

  ------------------------------

  Program Location:

  at Microsoft.AnalysisServices.AdomdClient.NTAuthentication.GetOutgoingBlob(Byte[] incomingBlob, Boolean& handshakeComplete)

  at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Authenticate(ConnectionInfo connectionInfo, DateTime startTime)

  Peter Gadsby
  Business Intelligence Consultant
  www.hgconsult.co.uk

• badri99

  Newbie

  Points: 5

  More actions

  May 25, 2012 at 8:26 am

  #1493196

  Hi,

  While connecting to the Cube through MS-Excel, you should give the Full address of the server, in the Server Name Text Box. eg:<Machine Name>\<Instance Name>,

  then select the Use Windows Authentication radio button

• mkheli@gmail.com

  SSC Journeyman

  Points: 81

  More actions

  December 9, 2013 at 5:15 pm

  #1672178

  Hi

  Visit this site :

  You could find how to do it in easy way

  Mnaouar Ben Khelifa

  Thanks