Forum Discussion
Cannot process database. Reason: Failed to save modifications to the server.
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?
I created a local account with a password(I was signed in with a windows account before) then when I tried to deploy the project, it worked.
3 Replies
You probably need to enter the credentials in SSAS. You can do this using SQL Server Management Studio:
Hope this helps
JJI did what you asked and it still didn't work. I entered the server with the "impersonate service account" option, and it successfully entered the server and pulled the information from there. I think the problem is with the analysis services since I can do everything but process the changes.
Thank you for your answer
I created a local account with a password(I was signed in with a windows account before) then when I tried to deploy the project, it worked.
