This post is just basically a SQL snippet for you to copy, paste and edit for use when you need to create a SQL database with a login and a user.

I use it when creating databases for Umbraco websites.

Just do a find and replace for 'mydatabase' with whatever you want to call your database and change the password of course!

USE master

CREATE DATABASE [mydatabase]

CREATE LOGIN [mydatabase-login] WITH password='supersecretpassword1=';

USE [mydatabase]

CREATE USER [mydatabase-user] FROM LOGIN [mydatabase-login];
EXEC sp_addrolemember 'db_datawriter', 'mydatabase-user'
EXEC sp_addrolemember 'db_ddladmin', 'mydatabase-user'
EXEC sp_addrolemember 'db_datareader', 'mydatabase-user'

Paul Seal

Umbraco MVP and .NET Web Developer from Derby (UK) who specialises in building Content Management System (CMS) websites using MVC with Umbraco as a framework. Paul is passionate about web development and programming as a whole. Apart from when he's with his wife and son, if he's not writing code, he's thinking about it or listening to a podcast about it.

Proudly sponsored by


  • Moriyama build, support and deploy Umbraco, Azure and ASP.NET websites and applications.

  • CI/CD service for Windows, Linux and macOS
  • Build, test, deploy your apps faster, on any platform.

  • is the easy error logging and uptime monitoring service for .NET.
  • Take back control of your errors with support for all .NET web and logging frameworks.
uSync Complete

  • uSync.Complete gives you all the uSync packages, allowing you to completely control how your Umbraco settings, content and media is stored, transferred and managed across all your Umbraco Installations.

  • More than a theme for Umbraco CMS, take full control of your content and design with a feature-rich, award-nominated & content editor focused website platform.

  • Affordable, Geo-Redundant, Umbraco hosting which gives back to the community by sponsoring an Umbraco Open Source Developer with each hosting package sold.