How to create New MS SQL Database Schema Instance

For creating New SQL Instance follow below steps.

Connect the MS SQL server and right click on Database for creating fresh instance.

Then, Select New Database

clip_image001

Give the Database Name and Click Ok.

clip_image002

Now, Create a Database login user.

Open Security tab and right click on Logins.

Select New Login

clip_image003

Give the Login Name and Select SQL Server authentication

Uncheck the “Enforce password policy” and at end select the default database then click OK.

clip_image004

Open the same login database properties and Select the User mapping. Select the same database that need to map .

And select the Database role its should be “db_owner”. So the current login user have all permissions.

clip_image005

Click Ok.

Once you click on Ok , Database instance permission will configured. Now you can login with that details and Check Database connection.

Click to rate this post!
[Total: 0 Average: 0]

Share and Enjoy !

Shares
Get Weekly KBV Tips !

Learn and improve day to day Knowledge & lifestyles.