Share via

The credentials provided for the SQL source are invalid.

Levent Gündoğdu 20 Reputation points
2023-07-20T12:57:36.55+00:00

I created a tabular project on analysis server using AdventureWorks2019 database. I succesfully imported the table I wanted to but when I deploy the project it gives the below error which is:

Cannot process database. Reason: Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: The credentials provided for the SQL source are invalid. (Source at msi;AdventureWorks2019.).

Does anyone have an idea of why this is happening?

User's image

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,193 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,993 questions
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,290 questions
0 comments
Accepted answer
  1. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-07-21T09:16:15.48+00:00

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. yunus emre ISIK 181 Reputation points
    2023-07-20T16:31:40.79+00:00

    Maybe your user has not enough privileges. Could you check your user ?

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.