Here are the instruction for  configuring the sql server linked server via CIS ODBC driver to access data from CIS.

Steps:

1, Install ODBC driver

2, Set up DSN to access CIS. Test the DSN before using it.

3, Open Microsoft SQL Server Management Studio, and make sure you install the "Microsoft OLE DB Provider for ODBC Drivers" in your SQLServer machine.

This will appear as MSDASQL under "Server Objects\Linked Servers\Providers in the SQL Management Studio where you are adding the new linked Server.


Here is one download link http://www.microsoft.com/en-us/download/details.aspx?id=20065 .
You can check with your DBA to download the correct one for your SQLServer instance.
4,You Need to change default options of "Microsoft OLE DB Provider for ODBC Drivers",
"Dynamic parameter": Enable
"Nested queries": Enable
"Level zero only": disable
"Allow inprocess": Enable
"Non transacted updates": Enable
"Index as access path": disable
"Disallow adhoc access": Enable
"Supports 'Like' operation": Enable


 

Restart SQLServer service process from Server manager.

5, Create Linked server with the provider as  "Microsoft OLE DB Provider for ODBC Drivers".

Data Source name is the System DSN you created in step2.

Product name can be anything

6, select Security panel, and select Be made using this security context, set Remote login: admin, With password: admin


 

then click OK.

The linked server should be created successfully