question

ThuPhan-8750 avatar image
0 Votes"
ThuPhan-8750 asked Zoehui-MSFT answered

Visual Studio - Cube Processing Error - The username or password is incorrect

Hi Everyone, I thought I posted this before but somehow I cannot find that post.
So I'm totally new to SQL Server and I'm making my first cube.

When I tried to process the cube, I kept getting error message "The username or password is incorrect. Could anyone please help to solve this issue? I've already changed the impersonation information to a specific Windows username and password as below.

Thank you so much.

195431-thumbnail-image.png


195230-thumbnail-image-1.png


sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Zoehui-MSFT avatar image
0 Votes"
Zoehui-MSFT answered

Hi @ThuPhan-8750,

This impersonation defines a Windows user which is used to access the Datasource; is important because you have to use Windows accounts for accessing the DB.

If your server is joined to a domain, you will have to specify DOMAIN\Username in the User name textbox and the associated password in the Password textbox.

A same thread you may take a reference to:

https://social.technet.microsoft.com/Forums/Lync/en-US/145b0ee0-f028-4f6c-9526-2ea0488d6bd6/the-following-system-error-occurred-the-user-name-or-password-is-incorrect?forum=sqlanalysisservices

Regards,

Zoe


If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.