I am trying to configure a connection between DB connect and my Microsoft SQL Server Management Studio.
Any idea of the type of drivers this DB works well with?
Could you clarify what you are trying to accomplish?
You don't connect DB Connect to SSMS, you connect DB Connect directly to the SQL Server database engine. Which drivers you use depends on which version of Splunk, Java, DB Connect, and Microsoft SQL Server you are connecting to.