Diadem Web Hosting Knowledgebase
Search:     Advanced search

MS SQL database creation

Article ID: 308
Last updated: 26 May, 2011
Add comment
Views: 2617
Comments: 0

Log in SQL Server Management Studio to create database.

 

Create a folder in "C:\SQLdomain\" as your domain name.

C:\SQLdomain\testdomain.com

 

Click right mouse button on Databases to open database menus and click New Database link.

 

Assign a Database name as dbuser.

 

Assign above mention path to Path tab in both the Logical Names(dnname & dbname_log) and click Ok.

 

Click right mouse button on Security then select New then click on Login to create new login.

 

Follow the steps for General page.

 

Follow the steps User Mapping page and click OK to accept the above settings.

 

Your are done, your MS SQL database has been created.

This article was:  
Add comment
Prev   Next
How to setup Remote Administration using Ammyy software on your...     Truncate SQL DBs remotely without admin privileges