Configure Microsoft SQL Linked Server with the ODBC Driver
This video demo shows you the process of configuring a Microsoft SQL linked server with the ServiceNow ODBC driver, allowing you to query tables from a ServiceNow instance directly via the ODBC driver.
This video applies to all supported ServiceNow releases compatible Microsoft SQL Server versions.
Role required: soap_query plus another role that provides read access to the tables you intend to query on the ServiceNow instance.
For best video quality, increase your player resolution to 1080p.
This video covers:
1:29 Configuring general and security settings
3:14 Testing the linked server
4:07 What to do if you get an error message
For more information on configuring Microsoft SQL linked server with the ODBC driver, see:
ServiceNow product documentation: Using ODBC Driver in SQL Server
ServiceNow knowledge base: Troubleshooting Linked Server
Microsoft support: How to determine the version and edition of SQL Server and its components
Your feedback helps us better serve you! Did you find this video helpful? Leave us a comment to tell us why or why not.
https://www.servicenow.com/community/in-other-news/configure-microsoft-sql-linked-server-with-the-odbc-driver/ba-p/2281618