To create the SQL Server database, the user must be a member of the dbcreator SQL Server role. This role can be assigned using SQL Server Management Studio, or with the T-SQL script provided below, but only by a member of the sysadmin fixed server role. This permission can be revoked once the database has been created.
The text in italics must be replaced with the user account to which the permission is being granted. The square brackets around the account name are required.
EXEC sp_grantlogin [DomainName\UserName]EXEC sp_addsrvrolemember [DomainName\UserName], 'dbcreator'