{"id":768,"date":"2018-04-30T21:10:51","date_gmt":"2018-04-30T21:10:51","guid":{"rendered":"http:\/\/orissawebhosting.in\/blog\/?p=768"},"modified":"2019-07-01T14:50:00","modified_gmt":"2019-07-01T14:50:00","slug":"how-to-create-mssql-database-and-access-the-database-via-ssms","status":"publish","type":"post","link":"https:\/\/orissawebhosting.in\/blog\/how-to-create-mssql-database-and-access-the-database-via-ssms\/","title":{"rendered":"How to create MSSQL database and access the database via SSMS"},"content":{"rendered":"

Create MS-SQL databases in Plesk\u00a0<\/strong><\/h4>\n

To create MS-SQL databases, you have to purchase VPS or DEDICATED server.<\/p>\n

http:\/\/www.orissawebhosting.in\/vps-hosting\/<\/p>\n

http:\/\/www.orissawebhosting.in\/orissa-dedicated-hosting\/<\/p>\n

In Plesk Panel, you create databases and then either create new users for it, or grant existing users access.<\/p>\n

kindly login to your plesk control panel in your browser.<\/p>\n

https:\/\/123.12.1456.125:8443 or\u00a0https:\/\/youraddomainname.com:8443<\/p>\n

\"\"<\/p>\n

Go to the\u00a0Databases >>Next page click\u00a0Add Database<\/strong><\/p>\n

\"\"<\/p>\n

Assign a name to your database within the\u00a0Database name<\/strong>\u00a0field and select the database server\u00a0MSSQL<\/strong>\u00a0from the\u00a0drop-down menu.<\/p>\n

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.<\/p>\n