要将API与SQL Server 2017集成，可以使用以下步骤和代码示例：

1. 安装SQL Server驱动程序：作为第一步，需要确保SQL Server驱动程序已安装在您的开发环境中。可以从Microsoft官方网站下载并安装SQL Server驱动程序。

2. 设置连接字符串：在API代码中，您需要设置一个连接字符串来连接到SQL Server数据库。连接字符串包括服务器名称、数据库名称、用户名和密码等信息。以下是一个示例连接字符串：

connection_string = "Server=server_name;Database=database_name;User Id=username;Password=password;"

3. 建立连接：在API代码中，使用连接字符串来建立与SQL Server的连接。以下是一个示例代码：

import pyodbc

def connect_to_sql_server(connection_string):
    try:
        conn = pyodbc.connect(connection_string)
        print("Connected to SQL Server")
        return conn
    except pyodbc.Error as e:
        print(f"Error connecting to SQL Server: {e}")
        return None

4. 执行SQL查询：一旦建立了与SQL Server的连接，您可以使用pyodbc库执行SQL查询。以下是一个示例代码：

def execute_sql_query(conn, sql_query):
    try:
        cursor = conn.cursor()
        cursor.execute(sql_query)
        print("SQL query executed successfully")
        return cursor.fetchall()
    except pyodbc.Error as e:
        print(f"Error executing SQL query: {e}")
        return None

5. 关闭连接：在完成与SQL Server的交互后，记得关闭连接以释放资源。以下是一个示例代码：

def close_connection(conn):
    try:
        conn.close()
        print("Connection closed")
    except pyodbc.Error as e:
        print(f"Error closing connection: {e}")

6. 完整的示例代码：

import pyodbc

def connect_to_sql_server(connection_string):
    try:
        conn = pyodbc.connect(connection_string)
        print("Connected to SQL Server")
        return conn
    except pyodbc.Error as e:
        print(f"Error connecting to SQL Server: {e}")
        return None

def execute_sql_query(conn, sql_query):
    try:
        cursor = conn.cursor()
        cursor.execute(sql_query)
        print("SQL query executed successfully")
        return cursor.fetchall()
    except pyodbc.Error as e:
        print(f"Error executing SQL query: {e}")
        return None

def close_connection(conn):
    try:
        conn.close()
        print("Connection closed")
    except pyodbc.Error as e:
        print(f"Error closing connection: {e}")

# Set connection string
connection_string = "Server=server_name;Database=database_name;User Id=username;Password=password;"

# Connect to SQL Server
conn = connect_to_sql_server(connection_string)

# Execute SQL query
sql_query = "SELECT * FROM table_name"
results = execute_sql_query(conn, sql_query)

# Print results
if results:
    for row in results:
        print(row)

# Close connection
close_connection(conn)

请确保替换代码中的“server_name”、“database_name”、“username”和“password”为您实际的SQL Server连接信息。