Managing users in SQL Server

To manage user accounts in a repository you need a Dataedo Administration Console. To run the console, choose Dataedo Administration Console from the start menu or run the file named DataedoAdministrationConsole.exe from the program installation folder.

If you don't see all the options displayed on screenshots, this is most likely caused by a graphics issue caused by Windows scaling. Check this link for a workaround.

Administration Console access

To be able to log into the console you need to have one of the following:

admins role in the repository database,
db_owner role in the repository database (this role is assigned by default to user that created repository),
sysadmin role on the server.

Logging into Administration Console

When you run the console, the login window will open. Type in the repository host name, database name and your server admin username and password and click Connect button.

Main view

Once you log in you will see a list of users.

The table shows all users defined on the server. Columns present:

Login - user login
Is Dataedo user - an indicator of whether the user is also a Dataedo user
License type - the type of a license for a Dataedo user - it includes a name of a license, unique ID, and a number of licenses the key includes.
Valid thru - for time-constrained license keys (trial keys or 1-year licenses) it displays a date key is valid thru. If the license key is expired date will be red.
Licensed for - the name of entity license was issued for (provided as License Holder at purchase).

Creating a free Dataedo user

Creating a user for existing server user

To create a user account for the user that already exists on the server (you can see a login on a list), double click user row - a window should appear:

Check Is Dataedo user field.

Now you can enter your license key (Pro or Trial). Just paste the key in the License key field.

Click Save and user gets created.

Creating a user for non-existing server user

To create a new user account, click Add user button:

A new User details window will open. Provide login and choose authentication mode. If you use SQL Server mode then you need to provide a password for a user. Type it into both fields below.

Note: You will not be able to change authentication mode after the user gets created.

Now you can enter your license key (Pro or Trial). Just paste the key in the License key field.

Click Save and user gets created.

Assigning and changing the license key

To assign or change a license key for a specific user double click user row - edit form will show. Paste the new key into the key field and save with Save button.

License key usage limits

Every license key has a limit of users it can be used for. When you save key, console checks amount.

Removing license key

To remove a license key from a user (you might want to use it for another user), double click user row and choose 'Free' in License type field and save with Save button.

Moving license key

To move license key from one user to another use instructions on removing and assigning keys above.

Checking license key

You can check what license type user has in the License type column. To check when the license key expires look at Valid thru column for a date. If the license key is already expired date will be red.

Changing password

To change the password of a Dataedo user double click user and type in the new password in both password fields and save with Save button.

Note: This option is available only for SQL Server authentication mode.

Removing user

To remove a license key from a user (you might want to use it for another user), double click user row and and uncheck Is Dataedo user field and save.

Note: Only Dataedo user will be removed - the user will still be defined on the server. To remove SQL Server login use SSMS or contact your database administrator.

Granting access to Administration Console

To grant the user access to the Administration Console you need to assign it admins a role in the repository database.

You can do it with SQL Server Management Console:

Connect to server
Expand repository database (by default it is "dataedo" database)
Go to Security > Users
Select user, right-click and choose Properties option
Check admins role on Membership tab
Confirm with OK button

To grant the user permission to create new users (logins on a server) user requires alter any login permission on a server.