question

SantoshV-2219 avatar image
0 Votes"
SantoshV-2219 asked ElsieLu-MSFT commented

Authentication issue with Project Odata in connection manager (SSIS)

Hi

I am trying to extract the Project Odata to SQL server tables via the SSIS package but getting the below error (image)

I have gone through a lot of forums before posting this question in forum

I am able to login with the same user name and password successfully in the browser and confirmed MFA is disabled

123616-project-online.png


office-sharepoint-online
project-online.png (38.4 KiB)
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.

SantoshV-2219 avatar image
0 Votes"
SantoshV-2219 answered ElsieLu-MSFT commented

This has been resolved by making necessary changes in portal.azure.com

Enable security defaults --> changed from Yes to No

· 1
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.

Glad to hear that, and thanks for sharing! :)

0 Votes 0 ·
ElsieLu-MSFT avatar image
0 Votes"
ElsieLu-MSFT answered ElsieLu-MSFT edited

Hi @SantoshV-2219 ,

As you mentioned, from the point of view of SPO, usually the reason for this error is that MFA is enabled. Did this error occur after some operations? Have you ever enabled MFA before? Also please try to restart the Editor and try again.

Check this thread for more information about how to disable MFA:
How to disable the two factor authentication from single user


If the answer is helpful, please click "Accept Answer" and upvote it.

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.