Create / Drop linked servers

Prerequisites

In order to follow the steps described on this page, the following conditions need to be met:

• Your organization has a customer account.
  (See: Create a customer account)

• You have a User Account with the necessary permissions.
  (See: Create a user account)

• You have a Project in your customer account.
  (See: Create a Project)

• You have created a Service Account.
  (See: Create a Service account)

• You have assigned the required project permissions to this service account.
  (See: Assign permissions to a service account)

• You have created an Access Token for this service account.
  (See: Assign authentication token to a service account)

• You have created a SQLServer Flex Instance.
  (See: Create a SQLServer Flex Instance)

• You are connected to the SQLServer Flex Instance.
  (See: Connect to a SQLServer Flex Instances)

• You have previously created a database..
  (See: Create databases in SQLServer Flex instances)

• You previously created a user and assigned the right server role to it.
  (See: Create user)
  (See: Server and project roles and permissions)

Create / Drop linked servers

To create linked servers, as described by Microsoft official documentation for SQL Server - Permissions - permissions are required - which are not granted in STACKIT SQLServer Flex, you can use the stored procedures provided by Microsoft via T-SQL.

Links to the official Microsoft documentation for linked servers:

• Linked servers (Database Engine)
• Create linked servers (SQL Server Database Engine)

Please ensure that the firewall and ACL on the target system is configured in such a way that incoming connections from the source system are allowed. This is a prerequisite for the functionality of the Linked Server.