Microsoft SQL Server - Artie

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

⌘I