Configure SQL Server
-
- UpdatedJan 30, 2025
- 3 minutes to read
- Yokohama
- API implementation
The following example configuration was performed on SQL Server 2008, installed on Windows Server 2008.
Before you begin
Procedure
What to do next
You may encounter precision errors querying for decimal
or number field values using the OPENQUERY syntax with the ODBC
driver. In this case, use the Cast syntax to convert the precision.
For
example:
SQL Server Connection String
To use the ODBC driver directly in SQL Server 2008,
specify the connection string in the following
format.
Note: The latest SQL Server 2008 patches are required for the ability to
specify a connection string in the user interface, via the SQL import
wizard
Using sp_addlinkedserver
The following example creates
a linked server named "ServiceNow ODBC" that uses
the Microsoft OLE DB Provider for ODBC (MSDASQL) and the data_source
parameter
After creating the linked server, you must update its properties to specify the login credentials.