Service Now - SCCM connectivity question

[Siva Sivaraman1]

Greetings   all,

As part of   asset management integration,   we are     trying to   get   data integration done between     Service Now (Geneva patch 😎   and   SCCM SQL database.   During this connectivity   testing process,   we ran into an issue on the       3rd part of the   testing   sequence:

1 we Verified that the user, "sccm_servicenow",   has the appropriate roles.

2. Resolved issue with user unable to connect from MID Server to the Windows server. We tested a powershell gwmi command to confirm this. (this I believe   eliminates port/firewall issue)

3     We need to verify if the user, "sccm_servicenow", can communicate from the MID Server to the actual SCCM Database. (At the     database level)

In this regard,     could someone provide some guidance/help as to   how   we   go about setting up a   remote   SQL   server   connection   from Mid   server   to     SQL   database   server under   SCCM   to get step   3 completed? what are things needed on the Mid server side to   get this   accomplished?

Service Now (Geneva patch 😎

SCCM

SCCM:
SCCM 2012 R2

WINDOWS:
Server 2012 R2

Mid Server

Windows Server 2012 R2 Standard

Thanks much

Kanagasabai Sivaraman (Siva)

Pacific Technology
UNIVERSITY OF THE PACIFIC
E:ssivaraman@pacific.edu

[JasonMMiller]

I'm upgrading from an old version and not quite where you are but I can answer this question. The easiest way to test if the MID server can talk to the SCCM SQL server is to use Windows' built-in ODBC Data Source Administrator (search ODBC). Add a user DSN and enter the server and sql user information on the subsequent screens. The last screen has a Test Data Source... button. If that works, you're set, and you can cancel the ODBC datasource creation. Keep in mind that you'll need a SQL user account for the connection if you don't have one. You may want to use the same username and password of your SNOW mid server account.

[Siva Sivaraman1]

Excellent idea...why did not I think this b4!

In fact I did ODBC for Excel to ServiceNow connectivity for external reporting....

Thx Jason

Sent via the Samsung Galaxy S ® 6, an AT&T 4G LTE smartphone