question

DominiqueDUCHEMIN-4668 avatar image
0 Votes"
DominiqueDUCHEMIN-4668 asked AndrewHowitzer-7693 commented

Connection SPLUNK to MEMCM

Hello,

I have MEMCM 2006 and I have Windows Authentication on the SQL Server hosting the SCCM Database CM_UCT...

I am trying to make a DBConnect link with Splunk using a jdbc string with Windows Authentication across the two domains.

The splunk server is in the domain AD

jdbc:sqlserver://10.16.102.120:1433;InstanceName:Configmgr;databaseName=CM_UCT;Domain=adtest;

but I cannot connect ...

The user account used is svc_ConfigMgr_SQL from adtest domain.
How to control the account used? the server name used? I am asking this as the service exist in several domains and I would like to confirm the one used is the one for the destination machine(SCCM Test) not from the origin machine (splunk)...

Any idea.
Thanks,
Dom

mem-cm-general
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.

DominiqueDUCHEMIN-4668 avatar image
0 Votes"
DominiqueDUCHEMIN-4668 answered AndrewHowitzer-7693 commented

Thanks,
The resolution was using a jtds connection...
Connection String: jdbc:jtds:sqlserver://VITSCCMCB.ADTEST:1433/CM_UCT;useCursors=true;domain=<domain_name>;useNTLMv2=true

Thanks,
Dom

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

Hi,

Thank you very much for your feedback and sharing. It may help others who have similar issue. If you have any questions in future, we warmly welcome you to post in Microsoft Q&A forum again.

Have a nice day!

Best Regards,
Simon

0 Votes 0 ·

Hi, I was using the same URL like

 jdbc:sqlserver://10.16.102.120:1433;InstanceName:Configmgr;databaseName=CM_UCT;Domain=adtest;

that was to complete my big data analytics using Splunk course. I also encountered the same problem. The following connection string worked well:

 jdbc:jtds:sqlserver://VITSCCMCB.ADTEST:1433/CM_UCT;useCursors=true;domain=<domain_name>;useNTLMv2=true

Thanks a lot!


0 Votes 0 ·
GarthJones-MVP avatar image
0 Votes"
GarthJones-MVP answered

This is a question for splunk. They will know the answer.

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.