Error while Add user to SSAS Server - The trust relationship between the primary domain and the trusted domain failed

Question

 

Team,

I am working in SQL Server 2005 Enterprise Edition.

When i am trying to add the user to SSAS Database Server , i am getting the following error

Right Click SSAS Server - > Properties - Security -> Add User and say OK

 

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

The following system error occurred:  The trust relationship between the primary domain and the trusted domain failed. .
 (Microsoft.AnalysisServices)

------------------------------
Program Location:

   at Microsoft.AnalysisServices.AnalysisServicesClient.SendExecuteAndReadResponse(ImpactDetailCollection impacts, Boolean expectEmptyResults, Boolean throwIfError)
   at Microsoft.AnalysisServices.AnalysisServicesClient.Alter(IMajorObject obj, ObjectExpansion expansion, ImpactDetailCollection impact, Boolean allowCreate)
   at Microsoft.AnalysisServices.Server.Update(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
   at Microsoft.AnalysisServices.Server.SendUpdate(IMajorObject obj, UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings, ImpactDetailCollection impactResult)
   at Microsoft.AnalysisServices.MajorObject.Update(UpdateOptions options, UpdateMode mode, XmlaWarningCollection warnings)
   at Microsoft.AnalysisServices.MajorObject.Update()
   at Microsoft.AnalysisServices.ManagementDialogs.ServerPropertiesSecurityPanel.OnRunNow(Object sender)
   at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.DoPreProcessExecutionAndRunViews(RunType runType)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.ExecuteForOlap(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.SqlMgmtTreeViewControl.Microsoft.SqlServer.Management.SqlMgmt.IExecutionAwareSqlControlCollection.PreProcessExecution(PreProcessExecutionInfo executionInfo, ExecutionMode& executionResult)
   at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)

Thanks

---

Liyasker Samraj K

Answer 1

Generally that error means that either the account you are trying to add is no longer in Active Directory Services, you have mis-spelled the name or that the account exists across a trust and the trust relationship is broken. Can you verify that the account has not been deleted? Can you permission the account on a share on the same machine as AS to test?

Answer 2

You are logged in to domain A

The SSAS server is on a server belongs to domain B

No trust relationship between A & B exists

 

---

Do NOT mark this as answer unless you are sure it is the right answer.

Raed Taha

Answer 3

This is a inter domain communication issue or firewall blocking the connections.

For the first can you need to verify if the trust between the two domains exists and if not then you need to create

verify :- http://technet.microsoft.com/en-us/library/cc737447(WS.10).aspx

Create :- http://technet.microsoft.com/en-us/library/cc758857(WS.10).aspx

For the second disable the firewall for the time being and check if your connection succeeds. 

 

Also as phil said you need to have the user id in at least one domain which has trust relationship set up with the other one.

---

Ashwani Roy

My BI Blog

My Entity Framework Blog

Please click the Mark as Answer button if a post solves your problem!