We have worked out a guide on SQL Server databases before, including creating, connecting, backing up and restoring a SQL database. Besides, we also listed the steps on how to create a database user.
By default, there is only 1 SQL login for each database and additional SQL logins for each database. However, with our Advance or Business plan, you are allowed to create multiple SQL logins for each database you created. Now, follow the steps in below to create multiple SQL logins for a single database.
1.Log into your WebSitePanel account using the method we listed in this guide.
2.Scroll down to Databases section and click SQL Server 2012.
3.In the new page, you can see that web have created 3 databases and 3 database users. Scroll down to the SQL Server 2012 Logins part and click Create User button.
4.Here, enter the user name you want to use, fill a strong password and confirm it. Next, choose a database which you are creating a login for. Here, we choose mywebsit_asd. Now, click Save button and you have successfully created a login for mywebsit_asd database.
5.Then, in the logins part, you can see that we have created a login successfully. To create additional logins for mywebsit_asd database, repeat step 4.