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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.......
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-22-2021 06:11 AM
created another account from sql dba.its working now.
