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
GO

CREATE DATABASE [mydatabase]

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

USE [mydatabase]
GO

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

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

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

  • Custom stickers for startups, artists and brands.
  • Bespoke easy-apply, removable, custom brand stickers printed in the UK.
elmah.io

  • elmah.io 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.
uSkinned

  • 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.
UmbHost

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