SCCM Integration - Use Integrated Authentication

euchye
Kilo Contributor

Hi all, I'm testing the SCCM integration after I've setup the MID server. After setting up the database server, database etc and ran the "Test data source connection", it failed. It was showing Error 18452 (not associated with a trusted sql server connection) and I am pretty sure the username and password are correct. So I proceeded to setting up the data sources. From some pages that I googled, I decided to set "Use Integrated Authentication" to true. The imports work like charm now even though the "Test data source connection" still fails. Did anyone encounter this?

cheers

2 REPLIES 2

euchye
Kilo Contributor

Added a sql user with dbowner role and it worked.


euchye
Kilo Contributor

I have 2 other instances of Service-Now which I have activated the SCCM plugin and I can't find the option to select "Use Integrated Authentication". I have tried to personalize the form layout but can't find the column name. What else should I do?