---
sourceDocument: Xanadu API Reference
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/xanadu/api-reference

 Release :

    - xanadu

ft:locale :

    - en-US

ft:publication_title :

    - Xanadu API Reference

ft:clusterId :

    - crapiref

bundleId :

    - crapiref

workflow :

    - Creator


---

# ODBC driver in SQL Server

# ODBC driver in SQL Server {#ariaid-title1}

* Release version: Xanadu
* 
* Updated August 1, 2024
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Use the ServiceNow ODBC driver in
SQL Server as a Linked Server.

Using the ODBC driver in SQL Server as a [Linked Server](http://msdn.microsoft.com/en-us/library/ms188279.aspx) allows SQL Server to query tables from a ServiceNow instance directly via the ODBC
driver. Only use the procedures described with SQL Server 2008 and 2012. Other versions of SQL
Server may cause unexpected behavior. If you encounter unexpected behavior, refer to the [troubleshooting linked server Knowledge Base article](https://support.servicenow.com/kb_view.do?sysparm_article=KB0538992).

## Required Permissions

Additional information on the required permissions for SQL Server Linked Servers can be found [on the MSDN blog](http://blogs.msdn.com/b/dataaccesstechnologies/archive/2010/08/19/permissions-needed-to-set-up-linked-server-with-out-of-process-provider.aspx).  
Note:  
Review this information if you encounter permission errors with SQL Server.
* **[ODBC SQL Server video tutorials](https://servicenow-prod.fluidtopics.net/lkdsAyEL0IWsSlFk0Ccduw)**   
  Watch video tutorials about configuring and troubleshooting the ODBC driver with a SQL Linked Server.
* **[Configure SQL Server](https://servicenow-prod.fluidtopics.net/11ZtObFgw04nAj5My0d44A)**   
  The following example configuration was performed on SQL Server 2008, installed on Windows Server 2008.