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 to Manually Add a Database (SQL 2005/2008)

To manually add SQL 2005/2008 First open SQL Management Studio on your server locally.

Step 1

Once SQL Management Studio is open click Connect.

kb-manually-add-sqldb-1

Step 2

Expand the master database and right-click Database then click New Database…

kb-manually-add-sqldb-2

Step 3

Name your database in the Database Name field and click OK.

kb-manually-add-sqldb-3

Step 4

You will now need to create a login to associate with the database.

Expand the security folder then right-click New Login.

kb-manually-add-sqldb-4

Step 5

You may now create the database user name, select SQL Server Authentication to assign a password.

Uncheck Enforce password expiration.

Select your database as the default database then click OK.

kb-manually-add-sqldb-5

Step 6

We now want to assign the database user the proper permissions.

Click on the User mapping page.

Click the check box next to your database.

Click the check box next to db_owner.

kb-manually-add-sqldb-6

Step 7

You should now test your login credentials remotely from your PC.

kb-manually-add-sqldb-7

Please open a support ticket if you have any questions or concerns regarding this article.

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.