Additional logins for private MS SQL

Overview

Adding a login to your Private MS SQL server takes two steps in two different places. You create the login itself in the Everleap Control Panel, which makes it exist on the server. You then assign it to a particular database using SQL Server Management Studio, which is what actually lets it read or write anything.

If you do only the first step, you will have a login that can connect but cannot see your data. That is expected, not a fault.

Step 1: Create the login in the Everleap Control Panel

  1. Log in to the Everleap Control Panel at cp.everleap.com.
  2. From the top menu click Databases, then Private MS SQL.
  3. Click Manage Login.
  4. Click Add Login.
  5. Fill out the fields and click Create Login.

Step 2: Assign the login to a database in SQL Server Management Studio

Once the login has been created through the Everleap Control Panel, connect to the database the login will be assigned to using SQL Server Management Studio. Once connected:

  1. Expand Databases.
  2. Expand the database itself.
  3. Expand Security.
  4. Right click on Users.
  5. Select New User.
  6. Leave the User type as "SQL user with login".
  7. Enter the new SQL login in both the User name and Login name fields.
  8. Click Membership.
  9. Add the role or roles you want the user to have.
  10. Click OK.

Verify it worked

Connect to the database with the new login. It should be able to do whatever the roles you granted in the Membership step allow, and nothing more.

If you cannot use SQL Server Management Studio

If you are unable or unfamiliar with connecting to the database through SSMS, add the new login through the Everleap Control Panel, then open a ticket with the Support Department and provide the database name and the role or roles to assign to the user.

Related Articles