All of the following commands need to be performed with sufficient access rights to be able to grant privileges on the newly created database.

The following command creates the database

CREATE DATABASE [Scolo]
go

The following command syntax will enable 'contained database authentication' on the database instance created above.

exec sp_configure 'contained database authentication', 1
go
reconfigure
go

alter database [Scolo]
set containment = partial
go

The commands below states to use your new database created above and to then create the user 'service_Scolo' with a password of 'password_Scolo' with access to only that database. The bulk operations permission is required by the application to insert image into the database.

-- create the login
USE [master]
GO
CREATE LOGIN [service_Scolo] WITH PASSWORD=N'password_Scolo', DEFAULT_DATABASE=[Scolo], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
-- add bulk admin role for saving BLOB images
ALTER SERVER ROLE [bulkadmin] ADD MEMBER [service_Scolo]
GO

-- create the user
USE [Scolo]
GO
CREATE USER [service_Scolo] FOR LOGIN [service_Scolo] WITH DEFAULT_SCHEMA=[db_owner]
GO
-- change the schema ownership
ALTER AUTHORIZATION ON SCHEMA::[db_owner] to [service_Scolo]
GO
-- change the database role
ALTER ROLE [db_owner] ADD MEMBER [service_Scolo]
GO