Diadem Technologies Hosting Knowledgebase

MS SQL database creation

Article ID: 308
Last updated: 26 May, 2011

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:   Report an issue


Article ID: 308
Last updated: 26 May, 2011
Revision: 6
Views: 2642
Comments: 0
print  Print email  Email to friend share  Share pool  Add to pool comment  Add comment
Prev     Next
How to Upload or Restore Database using Plesk Panel       Remotely Connecting to SQL Server