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

Thu Phan 1 Reputation point
2022-04-22T02:22:13.68+00:00

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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,261 questions
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,546 Reputation points
    2022-04-22T07:22:38.207+00:00

    Hi @Thu Phan ,

    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.