How to create MSSQL database and access the database via SSMS

Create MS-SQL databases in Plesk 

To create MS-SQL databases, you have to purchase VPS or DEDICATED server.

http://www.orissawebhosting.in/vps-hosting/

http://www.orissawebhosting.in/orissa-dedicated-hosting/

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.

 

Related posts

Leave a Comment