MS SQL database creation
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.
Related Articles
Backup and restore MySQL database with Plesk
Backup and restore MySQL database with Plesk Description: In Plesk, database dumps are created in the SQL format and saved as ZIP archives. If you need to create a dump in another format or to set custom settings for a dump, use the native ...Bulk email ID creation on Plesk
Bulk email ID creation on Plesk Follow the below steps to create Bulk Email ID on Plesk 1.Connect to the server via SSH/RDP. 2.Create a file mail.txt using any text editor with a list of mail addresses and passwords for it: example1@example.com ...Accessing MS SQL database using myLittleAdmin
To access MS SQL database using myLittleAdmin please follow the below steps. STEP: 1 Login to the Plesk panel and click on Website and Domains on left Menu Bar then select Database Option 1 and 2 will open the Database panel wherein option 3 will ...How to add MS SQL database in SolidCP
Steps to follow to add a SQl database in SolidCP Login to SolidCP. Once you are logged into SolidCP, click on All Customers link. In the next screen, you will see the list of all created users. If you have not created any user yet, you'll see the ...How to change MS SQL database user password from SolidCP
Steps to follow to change MSSQL database password in SolidCP Login to SolidCP. Once you are logged into SolidCP, click on All Customers link. In the next screen, you will see the list of all created users. If you have not created any user yet, you'll ...