Error in sccm integartion while loading the record MID Server reported error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SPA6sccm_integration'. ClientConnectionId:8864e3cd-75f8-43ff-b38b-4a5360e93eb

sahana3
Kilo Contributor

‎04-22-2021 04:04 AM

Hi All,

I am getting the below error while loading records in data source ,seems like its login issue with the service account,
tried changing password for service account again its throwing the same error ..can please some one check how this can be solved.

MID Server reported error: java.sql.SQLException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'SPA6sccm_integration'. ClientConnectionId:8864e3cd-75f8-43ff-b38b-4a5360e93eb7

Regards,
Sahana

0 Helpfuls
  • 1,948 Views
3 REPLIES 3

Sukraj Raikhraj
Kilo Sage

‎04-22-2021 05:31 AM

Did you reach out to the SQL server db admin? Validate that the account and pwd works....They are cases where if trying too many times, account on SQL side could get locked out.......

0 Helpfuls

sahana3
Kilo Contributor

‎04-22-2021 05:45 AM

this account has been created from AD account not from SQL end...so it should be created in sql right?

0 Helpfuls

sahana3
Kilo Contributor

‎04-22-2021 06:11 AM

created another account from sql dba.its working now.

0 Helpfuls