Configuring your SQL Server destination.
1433
) from the static IP.1024
to 65535
to the static IP.CREATE TABLE
privileges on the database.CREATE TABLE
permission in SQL ServerThe 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.SCHEMA
already existsBy 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.