Browse cube - Change User: The following system error occurred:  The user name or password is incorrect.

Environment: Windows Server 2012, SSAS 2012 (11.0.5058)

I have two identical SSAS Servers in the same domain. The SSAS project on machine B is a copy from machine A.

On machine A I can browse the cube using a different user using the Change User button. But this doesn't work on machine B. Any suggestions where to look?

Enlarge

February 27th, 2015 11:12am

Hi SSISJoost,

According to your description, you can browse the SQL Server Analysis Services cube in MachineA using the user IZP\bis2, the problem is that you cannot browse the same cube on MachineB using the same user, the error message is that "the username or password is incorrect", right?

In a SSAS project, the Browser button is used to browse the deployed cube. So in your scenario, the issue can be caused by that you have only copy the project from machineA to machineB without deploy it. To avoid this issue, you can deploy this project to ServerB. Or create an Analysis Services Project based on an existing cube on ServerA. Please refer to the link below to see the details.
https://technet.microsoft.com/en-us/library/ms365361%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396

Regards,
Charlie Liao

If you have any feedback on our support, please click here.

Free Windows Admin Tool Kit Click here and download it now
March 2nd, 2015 2:36am

Hi Charlie,

Cubes are deployed and processed on both machines and working fine... except for the Change User button which is used for testing certain parts of the cube.

March 2nd, 2015 8:08am

FYI... got the same error within SSMS

Free Windows Admin Tool Kit Click here and download it now
March 5th, 2015 5:11am

Hello Joost,

I am not sure,but you can try to remove and add your current user to admin role in "Roles" tab.

March 5th, 2015 6:46am

I just rebooted the entire server and suddenly it magically works again....
Free Windows Admin Tool Kit Click here and download it now
March 6th, 2015 3:10am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics