By default, there is only one SQL login when you start creating a database in WebSitePanel and Plesk. In this introductory tutorial, we’re going to explain how to create multiple SQL logins for one single database in detail.
How to Create Multiple SQL Logins in WebSitePanel?
In most cases, creating additional server or SQL logins for one database cannot be done directly. The good news is that there is a work-around solution for webmasters who have the Host4ASP.NET Advance and Business plans. Assuming that you are provided with the ability to create multiple SQL logins from the WebSitePanel interface, here are the detailed steps to create multiple SQL server authentications.
Create Your Own Database
To start with, you are supposed to log onto the backend of WebSitePanel with your account and username. From the menu page in below, there are plenty of editing options for you to control and manage a website from “Domains”, “Mail”, “Database” and many other aspects. If you haven’t had a database yet or you want to create a new database, you will need to move the mouse over the “Database” icon and choose “SQL Server 2012” as follows.
And then, make a hit on the “Create Database” button within this “SQL Server 2012 Databases” section. If done correctly, you will be prompted to fill in the “Database Name” of your requirement. In the meantime, you can take a look at the “Database Files”, “Maintenance Tools” and “Housekeeping Tools.” Once done, press the bottom “Save” button to take effect.
After the completion of database, you will be transferred to the previous “SQL Server 2012” page, and the newly-created database is now listed under the “Name” tab. As a matter of course, you can delete any unused databases by clicking the respective database link. As most hosting providers set strict limits on the number of database, you’d better handle your database with care.
Create Multiple SQL Logins
By rights, a “User” refers to a login entry into one single database; while a “Login” refers to the entry into the webserver. Besides that, the mentioned “Login” is usually associated with many users based on one database. Here, to create multiple user logins for one database, you will need to make a hit on the “Create User” button within the “SQL Server 2012 Logins” section as below.
In this “SQL User Properties” page, it is required to enter your username and password. At this place, we prefer to input the “primary” word in the blank text field next to the “User name” label. Make sure the filled-in password is as strong as possible. At the same time, you still need to select the newly-created database from the drop-down “Default database” list. Do not forget to hit the “Save” button to make it work.
If completed, WebSitePanel will automatically bring you back to the same “SQL Server 2012” page. Now, just repeat the above steps to input the “secondary”, “tertiary” or other easy-to-memorize words in the correspondent text fields. If nothing goes wrong, you will be able to have an overall look at all created logins as is displayed in the following picture.
Till present, you are able to log multiple server logins to one single database now. In the same way, you have the ability to delete the unneeded “User” by clicking its link and pressing the “Delete” button.
How to Create Multiple SQL Logins in Plesk Control Panel?
If you have the need to create multiple SQL logins from the Plesk control panel, you may refer to the following simple steps.
- At the very beginning, login to your Plesk account.
- Then, navigate to “Custom Websites” > “Databases” to create your wanted database.
- Hit the “Add New Database” button and you will be asked to create “Database Name” in the “General” section. Besides that, you will have to create a default database user by filling in specific “Database Username” and “Password.” At last, click the “OK” button to proceed.
- Go to the “Users” tab and click this “Add New Database User” button. From here, you should create another database username and password for the “secondary”” and even “tertiary” database users. If needed, you can choose to use the default user’s credentials to log to the database. Remember to press the “OK” button in the end.
- As you can see, there are multiple database users within this “Users” tab now. Obviously, you can remove the unnecessary one by checking its box and clicking the red “Remove” button.