> ## Documentation Index
> Fetch the complete documentation index at: https://artie.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft SQL Server

> How to configure Microsoft SQL Server as a destination in Artie

## Required settings

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

### Creating a service account

```sql theme={null}
-- 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
```