Configuring your SQL Server destination.
Create a rule in a security group or firewall settings to whitelist:
1433
) from the static IP.1024
to 65535
to the static IP.Create a database user to perform the writing of the source data.
CREATE TABLE
privileges on the database.Understanding the CREATE TABLE
permission in SQL Server
The CREATE TABLE
permission is a database level permission that allows for the creation of new tables in a given database. The user must also have the ALTER
permission granted on a given schema in order to create new tables in that schema (see the next step for details).
CREATE SCHEMA
privileges on the database if the schema does not exist.If the SCHEMA
already exists
By default, the service creates a new schema based on the destination configuration. If you prefer to create the schema yourself before connecting the destination, you may must ensure that the writer user has the proper permissions on the schema, using GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON SCHEMA :: <schema> TO <username>;
.
If the SCHEMA
already exists, the user does not need the GRANT CREATE SCHEMA
permission.
Securely share your host name, database name, port, your chosen schema name, username, and password with us to complete the connection.
Configuring your SQL Server destination.
Create a rule in a security group or firewall settings to whitelist:
1433
) from the static IP.1024
to 65535
to the static IP.Create a database user to perform the writing of the source data.
CREATE TABLE
privileges on the database.Understanding the CREATE TABLE
permission in SQL Server
The CREATE TABLE
permission is a database level permission that allows for the creation of new tables in a given database. The user must also have the ALTER
permission granted on a given schema in order to create new tables in that schema (see the next step for details).
CREATE SCHEMA
privileges on the database if the schema does not exist.If the SCHEMA
already exists
By default, the service creates a new schema based on the destination configuration. If you prefer to create the schema yourself before connecting the destination, you may must ensure that the writer user has the proper permissions on the schema, using GRANT SELECT, INSERT, UPDATE, DELETE, ALTER ON SCHEMA :: <schema> TO <username>;
.
If the SCHEMA
already exists, the user does not need the GRANT CREATE SCHEMA
permission.
Securely share your host name, database name, port, your chosen schema name, username, and password with us to complete the connection.