Required settings

  • Host name
  • Port (default is 1433)
  • Service account
  • Database name
  • Schema name (default is dbo)

Creating a service account

-- Create a service account
CREATE LOGIN artie_transfer WITH PASSWORD = 'AStrongPassword!';
GO

USE database;
GO

CREATE USER artie_transfer FOR LOGIN artie_transfer;
GO

-- If it's not dbo, change the schema name
GRANT ALTER ON SCHEMA::dbo TO artie_transfer;
GO

GRANT CREATE TABLE, INSERT, UPDATE, DELETE TO artie_transfer;
GO