Coupon code copied
Server Intellect
(855) 850-HOST

Toll Free 24/7/365        (4678)

Get help from a Microsoft Certified Engineer.

Intellect Connect

Technical problem with your Windows Hosting?

Let our Microsoft Certified experts handle the problem for you.

How do I Create a Database and User in SQL Server Management Studio?

Open SQL Server Management Stduio and connect to the database server as a sysadmin. This can be done by logging on locally using Windows Authentication, or externally by using the ‘sa’ credentials.

Right-click on “Database” and select “New Database“. Enter the name of your database and click OK to create the database.

Right click on “Security” in the left pane, and select “New“, then “Login“.

Enter the desired user name, and select “SQL Authentication“, then enter the desired user password. Ensure to uncheck the “Enforce password expiration” option.

Select your new database as the Default database, and click on User Mapping on the left side. Click the check box next to your database, and click the check box next to “db_owner“.

Lastly, click OK to create the login and database user.

Interested in letting our experts solve your IT problems for you?
Get a free, no-obligations consultation with one of our experts today!

Call us at (855) 850-HOST

Contact

Start Your Order

X

This form does not accept free e-mail accounts. Please enter a business e-mail to submit it.

Submit Form Cancel

Please wait...

Submitting your info. This may take less than a minute.