About Reflex Solutions banner
Reflex Solutions Clients and Partner Logos: AVI, Microsoft, Avaya, HP, Asigra, VMWare

Creating SQL Server Database and Database User

 Move your mouse cursor over “Databases” then click “SQL Server 2012”.
 To create a new SQL Server database click “Create Database” button.
 Specify database name and click “Save” button to finish the wizard.
 The next step is to create database user account and associate it with the database.
 To create database user account click “Create User” button.
 Specify username, password and then in “Databases” sections tick those databases you want to grant access for this user account. Database user will granted “db_owner” role in the selected databases.
 You could specify “Default database” as well. It’s an optional field, but once selected the name of the database could be omitted from connection string of your application.
 Click “Save” to complete the user creation.


Back to Top