Create MS-SQL databases in Plesk
To create MS-SQL databases, you have to purchase VPS or DEDICATED server.
In Plesk Panel, you create databases and then either create new users for it, or grant existing users access.
kindly login to your plesk control panel in your browser.
https://123.12.1456.125:8443 or https://youraddomainname.com:8443
Go to the Databases >>Next page click Add Database
Assign a name to your database within the Database name field and select the database server MSSQL from the drop-down menu.
A database must have at least one user account associated with it. Otherwise, it will be impossible to access the database. You can create a database user while creating a database by selecting the Create a database user check box. Alternatively, you can select a user later, for example, if you want to use one of the existing user accounts.
- Select Create a database user. if you want to create a new user for this database and enter a username and password for it. Otherwise, deselect the option.
- Assign a username to your database within the Database username field.
- Assign a password to your database user within the New Password field.
- To use the database user for accessing any of your databases, select User has access to all databases within the selected subscription.
- Click Ok
Now your database will now be set up and ready to use. You can import and export the database from your local.
How to access the database via SQL server management Studio
Install SQL Server Management Studio
Open SQL Server Management Studio. You will be presented with a logon dialog.
Replace “server_name” with your assigned server “IP address”. In the Login field replace “user” and in password “enter user’s password”.
Once completed, Click “connect” to access the database.
The SQL Server Management Studio has been connected successfully.